Dlookup Returns Error

S

Samaa

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?
 
S

Samaa

The Code i wrote is
=DLookUp("Code","Items","Item= " & Chr$(34) & Me.Item & Chr$(34)
in the Code Text box in the form and i get the error "#Name?"
 
Top