Combo box writes wrong column to table

[fflei]

I used the combo box wizard to make a combo box which draws its list from a
table called Location. The table consists of only two fields, LocID and
LocName, which is a text field.

I selected LocName as the list I wanted and chose the option to hide the key
column and chose to store the value in a field called Loc1 on the main table
to which the form is bound.

The combo box works fine on the form, but why does it write the value in the
key column to the other table instead of the text? (I have checked, and the
field is a text field with sufficient space for the data).

I'm flummoxed, so if anyone knows the answer to this I'd be really grateful
to hear!

Fflei

 

[Timothy C. Doherty]

Check the "Bound Column" property of the combo box. This specifies which
column is bound to your data source. If your columns are 1)LocID and
2)LocName, specify column 2 as the "Bound Column"