Combo Box on form with Product Name instead of ID

[Shane_Mc]

Hi all,

Just gettin back to some Access after a looooong break and there is something bugging me. I know I was able to do it before but can't for the life of me remember how.

I have a form for entering a new Products for a particular supplier.

Naturally I have a tblProduct and tblSupplier.

What I want to happen on the form is have a Combo Box with a list of SupplierNames in it. And, have a hidden text box on the form that will insert the SupplierID not the SupplierName in the SupplierID field in tblProduct when the form is submitted.

Sorry bout the roundabout explaination. Any help with this would be greatly appreciated.

S

 

[GumbyD]

In the "Row Source" property of the combo box select a query that you created the has the code and description in it. Then in the "Column Count" put 2. In the column widths property put 0,2. In the "Bound Column" put 1 (that will bind the field to the code). In the "List Width" put 2.0. If you do that it will display the descriptions in the drop down but save the code to the field. If that is not exactly what you want you can play with those properties.

GumbyD