dlookup with date field as parameter in ADP

[FRED]

I have a from with two text fields field1 and field2. I have one table
"table1" with two fields: date (datetime) and period (numeric). I want the
period to be return in the field2 when I key the date in field 1. I tried
Dlookup("period","table1","date = #" & [field1] & "#") but it doesn't work in
ADP. I tried in MDB and it works. . . . any Idea ???

Thanks

FRED

 

[Sylvain Lafontaine]

Use single quotes around the date instead of #.