dlookup() problem

J

Joshua

Hello,
I am using dlookup() to choose fields in a table
based on the values entered in 3 combo boxes.
Since on of the combos contains a date field, filled in by
a now() function, I am using the dlookup as follows.


=DLookUp("[Reference_price]";"archive2";"[DealID]= '" &
[Forms]![AREA]![Combo38] & "' AND [Model-Nr]= '" & [Forms]!
[AREA]![Combo36] & "' AND [Changed On]=# " & Format
([Forms]![AREA]![Combo22],"mm/dd/yyyy")& "'#")
(following the suggestion that I recieved yesterday from
the same newsgroup.
This returns a syntax error..plz help!!!


thanks a lot!

Joshua
 
Top