fbpx
Logo
Mail us
ben@accessdatabasetutorial.com
accessdatabasetutorial
Home » Modules » Microsoft Access Database: Access DLookup Function Example with Access VBA

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.

Tags: , , , , ,

3 Responses so far.

  1. 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?

  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.

Leave a Reply

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