Dlookup Returns Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?"
 
Back
Top