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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dlookup 2
Dlookup is broken... 1
DLookup and Nz 0
DLookup Syntax Problem 1
DLookup Function 2
Dlookup error 13 7
Dsiplay a combo box 1
DLOOKUP 2

Back
Top