Access VBA

css navigation by

DLookUp with Two Criteria

I had the idea that you could use more than one criteria in a dLookUp but had a hard time finding an example.
DLookUp("FirstNameMI","[BorrowerInfo]","DVid=" & [ID] & " And BorrowerType='B2'")

Return “First Name” from the “BorrowerInfo” table, where the ID in “DVid” is the same AND the “BorrowerType” is B2

Everything is exactly the same as one criteria except that you add the word “And” to join them together.

© 2009-2023

Updated:  09/16/2023 18:53
This page added:  12 February 2009