DLookUp comparing more than 1 field

[Allen Browne]

Your example should work if EmbID and DesignID are both fields of type
Number.

If DesignID is a Text-type field, you need quotation marks around the value.
The 3rd argument would be:
"[EmbID] = " & [EmbID] & "AND [DesignID] = """ & [Designid]) & """"

 

[Fishiee]

Hi,

Can we retrieve a value from a table to a textbox of a form by comparing
more than one field using DLookUp?
If yes, then what would be the syntax for comparing text fields and number
fields?

I have used following code but does not work:
CONTROLSOURCE= DLookUp("[Price]","DesignerCost","[EmbID] = " & [EmbID] & "
AND [DesignID] = " & [Designid])

however this one works but its not what I wanted as output:
CONTROLSOURCE= DLookUp("[Price]","DesignerCost","[EmbID] = " & [EmbID] )

Pls help,
Thanx in advance,
Sumit

 

[Fishiee]

Hi,
Answer to my own question:
Sorry I made a mistake with second field name but the syntax was right.
Thanx anyway,
Sumit