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??
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??
Combo box columns are zero based so assuming it is bound to the ID field as the first column (0), you just use
Code:Me.comboboxname.Column(1)
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.
apologies, but where would i input this new code? in the form/design area?
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.