Microsoft Access Database: Access DLookup Function Example with Access VBA

Microsoft Access Database: Access DLookup Function Example with Access VBA

Take a look at this six and half minute video of how to utilise the Access DLookup function using a little of Access VBA code too (not too difficult but necessary in this example).

Microsoft Access Database: Access DLookup Function Example with Access VBA

Of course you do not have to use Access VBA code when applying the Access DLookup function. Instead, you can populate fields by using a calculation or auto-lookup query instead.

Access DLookupWith the calculation method however, this is just an expression and will not be updatable should data in fields need to be edited.

Take a look at my eBook on More Access Database Queries to learn about the ‘Auto Lookup’ query and other more adavnced techniques.

This entry was posted in Modules, MS Access, Tables, VBA and tagged , , , , . Bookmark the permalink.

3 Responses to Microsoft Access Database: Access DLookup Function Example with Access VBA

  1. Ben says:

    Please give an example of what you have tried to do so far so someone can help edited your syntax.

  2. mah says:

    I have two tables A and B
    I want use dlookup to search about Name in table A by Name Id, and Name Id in table B related by Box Id
    i.e., we insert Box id and we want get name.

  3. Ben Beitler says:

    I would be keen to know from other fellow Access developers/Power users who have used the DLookup function and which object they typically use it along with any VBA code?

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Confirm you are human.