Using AND in DLookup function

aqif

Registered User.
Local time
Today, 20:11
Joined
Jul 9, 2001
Messages
158
Hi
smile.gif


is it possible to use Dlookup Function Like

Dlookup("FieldName","TableName","FieldName1= " & Forms!Form1!Text1 "AND FieldName2= "& Forms!Form1!Text2

I am trying to match tow conditions in Lookup function...any suggesstions?

Cheers!
Aqif
 

Users who are viewing this thread

Back
Top Bottom