Using DLookup in a subform

[hrseebeck]

I have a form called frmQuote and a embedded form inside it called frmQuoteProd. I want to select a product from the drop-down menu and have a dlookup enter the product name into a new text box. Every way I do a DLookup I am getting an error. Can someone assist me in setting up a dlookup? I have attach my test database that is in Access 07. Thank you for your help.

 

[pbaldy]

For starters, this would be more efficient if appropriate:

http://www.baldyweb.com/Autofill.htm

Second, your syntax to refer to the subform is off:

http://www.mvps.org/access/forms/frm0031.htm

Third, your field is text so requires a different syntax:

http://www.mvps.org/access/general/gen0018.htm

But simplest is my first link.

 

[hrseebeck]

Thank you so much! Your first suggestion worked like a charm.

 

[pbaldy]

Happy to help. That's more efficient anyway, as it avoids the extra trip to the data.