This video explains the DLookup function in MS Access data base with vba codes.In Access desktop databases you can use the DLookup function to get the value of a particular field from a specified set of records (a domain). ... You can use the DLookup function to display the value of a field that isn't in the record source for your form or report.