Combo Box Drop-Downs

[victor2525]

I created a 2-column drop-down combo box in a form, but when I select the item I want, its ID # is recorded in the corresponding table rather than what is listed in the drop-down box. How do I fix this??

[isladogs]

Combo box columns are zero based so assuming it is bound to the ID field as the first column (0), you just use

Me.comboboxname.Column(1)

[pbaldy]

Saving the ID is what you'd normally do; that's kind of what it's for. That said, the Bound Column property of the combo determines which field is saved.

[victor2525]

apologies, but where would i input this new code? in the form/design area?

[isladogs]

In the same place as you put the original code....

[pbaldy]

I don't think there is any code. Combo is working as it normally should, OP is expecting text value to be saved instead of ID.

[isladogs]

Hi Paul - probably true - just thought some sort of answer might help the OP move on ...