AutoFill Based on ComboBox Selection

[chelseagardens]

Hopefully my title is accurate for what I'm attempting to do, but I created a form (ProductIssdF) with a combo box that includes a list of item descriptions from a table: ProductListT. What I would like to happen is that once an item description is chosen within the combo box, a product ID is automatically filled in from the information on ProductListT. I attempted to do this using dlookup. The following is the information I typed into the expression builder:

=DLookUp("ProductID","ProductList","ItemDescriptio n='" & [Forms]![ProductsIssdF]![Combo54] & "'")



Mind you, "combo54" is the combo box I created with the list of item descriptions. Now, when I go to form view and select something from the combo box nothing happens within the product ID text box! It's so frustrating! I am a very new user so I have no earthly idea what I have done wrong here. Any suggestions?

[pbaldy]

Does this help?

BaldyWeb - Autofill

[chelseagardens]

So I've tried your suggested method of getting what I want and it seems like it will get me my desired result, the issue is that I get the following message when I try to select something from the combo box:

"Microsoft Access cannot find the object 'me' If 'me' is a new macro or macro group, make sure you have saved it and that you have typed its name correctly."

Any thoughts on that?

[pbaldy]

I suspect you have it directly in the properties window. What I posted was VBA code, and goes here:

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