DLookup mystery!

[iazcac]

Hi,

My brain hurts over this one, and is probably v obvious!!

I have a form with subform in my database. I want the user to enter the code number and the supplier number, and then use the DLOOKUP function to display code name and supplier name.

I have successfully done this for the code, but cannot get it to work to supplier name. It comes up with #Error. I have copied the syntax exactly (changing the table and field names) but I cannot get it to work

Any help appreciated. I have attached a copy of my DB

Thanks
Chris

 

[iazcac]

this time attached!

 

[boblarson]

Use forms and not lookups in tables. In fact run as fast as you can away from lookups in tables as it will only cause you grief.

 

[iazcac]

Hi Bob,

Thanks for the reply.

Can you point me in the right direction for forms please as not quite sure what you mean

Thanks
Chris

 

[boblarson]

In the subform what are you trying to do? Are you assigning existing products to a date/planner or are you trying to add products?

 

[unclejoe]

Hi,

Try without the quotes, like

=DLookUp("VendorName","tblSuppliers","VendorNo=" & [VendorNo])

Your column "VendorNo" is a Number datatype and a double.

this time attached!