Clicking on item in combo box doesn't put it in the top box

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I have a combo box that has an accurate list generated by a SQL query but
when I select one from the list, only the first item in the list ever goes
in the top "selected item" section of the combo box.

Where to look?

Rob
 
I have a combo box that has an accurate list generated by a SQL query but
when I select one from the list, only the first item in the list ever goes
in the top "selected item" section of the combo box.

Where to look?

Rob
Click to expand...

Check the Control Source (the field in your form's table into which
the selected value will be stored), the Bound Column (which field in
the combo's rowsource will be stored there), and the ColumnWidths
property (which controls what you'll see when the combo is not dropped
down - you'll see the first nonzero width field).
 
There is no control source because the source is code. (which is working)
I also have the bound column set to the ID fields of the data and am hiding
2 fields and displaying 1 field.

Do I need a control source for some reason?
 
I found the error.
I had it bound to field 1, should have been bound to field 2.
Thanks,
Rob
 
Back
Top