Dlookup Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Are there a maximum number of arguments that can be put in the Vlookup
function? I know the Dlookup function will return the first occurrence if
more then one field meets the criteria but I sure I am using the right
syntax. Here is the function the way it is in my code:

TempStr = Nz(DLookup("[ContactName]", "Contact", "[ContactType] = '" &
Me!ContactType & "'" _
& " AND [ClientNumber] = " & Forms![ModifyClient]!ClientNumber _
& " AND [Prime] = True"))

All is ok but don’t seem to take care of the last criteria [Prime] = True.
It come up with the right ContactType and ClientNumber but will return the
first occurrence that meets those 2 criterias.

Am I doing something wrong?
 
Back
Top