Dlookup and 'and'..?

[kenjoswe]

Hi all,

I would like to lookup a value from a table with lookup.
How can I use dookup with two criterias?
I have tried:
intValue = DLookup("Field1", "Table1", "Field2=" & Me.Ctrl1 and "Field3='" Me.Ctrl & "'"

Is there a better way to lookup a value from table?

/Kent J.

 

[Craig0201]

intValue = DLookup("Field1", "Table1", "Field2=" & Me.Ctrl1 & " AND Field3='" Me.Ctrl & "'&quot

Craig

 

[LTKDBS]

Try:

intValue = DLookup("Field1", "Table1", "Field2=" & Me.Ctrl1 & " AND Field3='" Me.Ctrl & "'"


The 'AND' needs to be part of the Where Clause / Condition.