DLookup 1

[primerov]

I need a help with the DLookup function. The control in my form has a DLook function
to look up the value from the table TblOrderDate, the field OrderDate, where ID = 1
ID is the autonumber in the table.

The control source has the following line
DLookUp("OrderDate", "tblOrderDate", "ID=1")
However, i receive the question Name ?
What is wrong with my code ?

 

[Gavroche00]

Dear Primerov,

I believe you need to insert your field name in brackets with double quotes around it.

Try: DLookup("[orderdate]","tblOrderDate", "ID=1")

David