Combo box not inserting data from list

  • Thread starter Thread starter Tony Girgenti
  • Start date Start date
T

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
 
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?
 
For 2nd question, I think you meant the Form's RecordSource, not the
ComboBox RowSource???
 
Back
Top