Combo Box on Form does not save correctly to table

[Bandit]

I got a combo box on my form. The combo box lists our suppliers. When I
save the form and check the table to ensure the info was stored properly, it
shows the Supplier ID in the column instead of the name. I have deleted and
rerun this combo box a dozen times and can not fiqure out where my error is.
I have another form that I created with the combo box listing the suppliers
using the same table. That second form saves the supplier info correctly. I
have looked at properties in both forms to see if I see the problem, but I do
not. Can someone please help me?

 

[Beetle]

Assuming that this combo box is on a form that has a different table (not the
Suppliers table) as it's recordsource, then it sounds like it is working
correctly. For example, say you have tblPurchases, and on the Purchases form
you have a combo box to select the supplier. The only thing that should be
stored in tblPurchases is the SupplierID, not the name.

Then again, maybe I've misunderstood your post.

 

[Ron2006]

The key to the answer is what field is the bound field in the combo
box.


if there are 3 fields that are selected in the query behind the combo
(and it does NOT mater whether they are shown or not) the information
that is saved is whatever field is behind the column number that shows
in the bound column property of the combo box.

Ron