Dlookup Returns Error

message from =?Utf-8?B?U2FtYWE=?= on 30 May 2004
I need help in doing the below.
I have a table called Item where i have Item Field and a Code Field. i need to create a form where a combo box lists the Item and when any record is selected the code is reflected ina code text box in the form. can any one help me with that?
 
=?Utf-8?B?U2FtYWE=?= replied to =?Utf-8?B?U2FtYWE=?= on 30 May 2004
=DLookUp("Code","Items","Item= " & Chr$(34) & Me.Item & Chr$(34))
in the Code Text box in the form and i get the error "#Name?"
 

Archived message: Dlookup Returns Error (Microsoft Access Forms)