Combo Box - Can't Select Item

[Mot]

I have a combo box on a form that will not permit me to
select an item from its list.

I've actually tried to develop this form a couple of
different ways, and they all fail in the same way. The
list drops open and is populated correctly. I click on
an item in the list and instead of replacing the value in
the textbox portion of the control and closing the list,
the list just remains open and does nothing.

The cbo is bound to a query. I have also tried to use a
cbo in un-bound mode and programmatically set the list in
form load; same problem.

Other forms in this mdb have cbo's that work normally. I
can't detect any setting within the form or cbo that is
causing this behavior.

Any help very much appreciated!

 

[Rick Brandt]

I have a combo box on a form that will not permit me to
select an item from its list.

I've actually tried to develop this form a couple of
different ways, and they all fail in the same way. The
list drops open and is populated correctly. I click on
an item in the list and instead of replacing the value in
the textbox portion of the control and closing the list,
the list just remains open and does nothing.

The cbo is bound to a query. I have also tried to use a
cbo in un-bound mode and programmatically set the list in
form load; same problem.

Other forms in this mdb have cbo's that work normally. I
can't detect any setting within the form or cbo that is
causing this behavior.

What about the form's AllowEdits property?

 

[Bruce M. Thompson]

What about the form's AllowEdits property?

And make sure the combo box's "Locked" property is set to "No".

 

[Van T. Dinh]

Technically speaking, you don't bind the ComboBox to a Query. You can use a
Query as the RowSource of the ComboBox. In addition, you can set the
BoundColumn of the ComboBox which indicate which Column of the List the
ComboBox will take the Value from.

After that, you can bind the ComboBox to a Field of the Form's RecordSource
or , of course, you can leave it unbound.

Check the following:

1. The ComboBox' Locked Property.
2. If you have the bound Form / bound ComboBox, check and make sure that
the Form's Recordset is updateable.
3. The Form's AllowAdditions and AllowEdits Property.
4. (not 100% sure on this) Make sure the BoundColumn of the ComboBox and
the Field that binds the ComboBox are of the same type.

 

[Mot]

-----Original Message-----


What about the form's AllowEdits property?


.

D'Oh! Apparently this was it. I can switch between the
desired and the unexpected bahaviors by toggeling
AllowEdits. Ironically, the forms I originally worked
with were all created using the Form Wizard. Wouldn't
have thought it would create a non-editable form. Live
and Learn.

Thanks for the help!

 

[Ken Snell]

And that the combo box is not bound to a field in a nonupdatable query.