ComboBox text field not populating when clicking on dropdown item.

[mmaule]

How do i get the ComboBox text field to populate with selection from dropdown list? I created the box using the Control Wizzard and it displays the field values correctly but when i make a selection the box does not update.

[zeeshanaslamdurrani]

Hi .... please set the coloumn bound and coloumn count fields of the combo box. You'll find these fields in the properties of combo box. Just double click the combo box and a property box with show check for the coloumn bound field and coloumn count field. Column count shows how many colounms you are selecting. Coloumn bound shows which column you are binding with the combobox. So try to change the value of coloumn count to 1 or 2 depending on which column you want to select. I think your problem will be solved.

[ItsMe]

After you follow instructions in post #2, if you want the Value property of your combo to populate a field within your form's recordset, add the field's name to the Control Source property of the Combo. You can choose to display the result in a bound textbox control if you wish.

If you only want to display text in an unbound control and not store any data in your table, use VBA to update the value of the unbound textbox control.

[mmaule]

I'm trying to capture a unique value from a field to set the table filter.
I am using a Row Source of "SELECT DISTINCT DirUnit.System FROM DirUnit;", ColumnCount of 1, BoundColumn of 0.
My arrow keys do not move up and down the selection dropdown list, and selecting an item by mouse, highlights the item, but does not populate the combobox selected item field.

[ItsMe]

...BoundColumn of 0...

THe index for Bound Column starts at 1 and the index for columns in VBA starts with 0

You can not have a BoundColumn of 0 in the property sheet. Try BoundColumn of 1

Not sure if this will solve your issue but does need to be corrected.

[mmaule]

Thanks, I set the Bound Column to 1 but still no change.

[ItsMe]

The only thing I can think of is the properties of the form. Make sure the form's Allow Edits property equals Yes.

There may be another property that will cause a similar symptom but Allow Edits = No will cause what you describe.

[mmaule]

Thanks! That fixed it.