Combo box not inserting data from list

[Tony Girgenti]

Hello,

I inserted a combo box onto a form using the combo box
wizard and chose "I want the combo box to look up the
values in a table or query." When I go into form view,
the dropdown list works and displays the data rows, but
when i select a row, it does not put the bound column of
the row into the field. Also, I can't type anything into
the box.

I tried help on everyone of the properties of the combo
box and have no luck in making it work the way it should.

Any help with this problem would be greatly appreciated.

Thanks,
Tony

 

[Ken Snell]

Some possible problems to check:
--
Ken Snell
<MS ACCESS MVP>


Are the form's AllowEdits and AllowAdditions properties set to Yes?

Is the query that is the combo box's Row Source an updatable query?

Is the combo box bound to an autonumber field in the form's Record
Source?

Post the SQL of the combo box's RowSource. Also, what message do you see on
the StatusBar (the grey bar at the bottom of the screen) when you try to
make a selection in the combo box?

 

[Van T. Dinh]

For 2nd question, I think you meant the Form's RecordSource, not the
ComboBox RowSource???

 

[Ken Snell]

Yes, that is what I meant < g > !

Thanks for the doublecheck, Van!

 

[Tony Girgenti]

Thanks Ken.

It was the first option that did it.

Tony

 

[Ken Snell]

Glad you found it.

Thanks Ken.

It was the first option that did it.

Tony