Combo Box won't select!!

  • Thread starter Thread starter BBM
  • Start date Start date
B

BBM

Under what circumstances will a combo box show the
possible values (in my case a table in the database) but
NOT let you select one of the values to be the value of
the combo box?

The control is unbound.

The control is on the header portion of a form that is
primarily just for picking a record to edit, so the form
is marked for no additions or edits. Changing these
values on the form doesn't help.

The control is enabled.
The control is not locked.
Limit to list is true.
Column 1 is the bound column (which I thought just set the
value of the control if the control is unbound).

When I run the form, the effect is just as if the combo
box was locked (with nothing selected, there's no
default). The proper table values show correctly, but you
cannot select any of them.

I'm using Access 2003.

What is going on?

Thanks.
 
Do you see a "message" in the Status bar at bottom of the form when you try
to select an item?
 
Only the status bar text associated with the combo box.

I've also tried intercepting the BeforeUpdate event. It
never gets called. It's like the control is locked.

Again, if it makes a difference, the combo box is on the
header portion of a "continuous" form. The form is bound,
but the combo box is unbound.

BBM
 
Is there any code running in the form's OnCurrent or OnLoad or OnOpen event?
An unbound combo box in a form's header is a standard way of setting up a
continuous forms view where you're using the combo box to "filter" the
records to be displayed, so what you describe is not a normal behavior.
 
If you set the Form's AllowEdits to False / No, you cannot
change any value od *any* Control on the Form, even
unbound Controls.

HTH
Van T. Dinh
MVP (Access)
 
BBM said:
Under what circumstances will a combo box show the
possible values (in my case a table in the database) but
NOT let you select one of the values to be the value of
the combo box?

The control is unbound.

The control is on the header portion of a form that is
primarily just for picking a record to edit, so the form
is marked for no additions or edits. Changing these
values on the form doesn't help.
Click to expand...

Are you sure about changing the AllowEdits property? That _will_ lock all
controls on the form (including the unbound ones).
 
I re-tested allows edits and setting it to yes allowed my
control to work properly.

Thanks for your help.
 
-----Original Message-----


Are you sure about changing the AllowEdits property? That _will_ lock all
controls on the form (including the unbound ones).
Click to expand...
Rick:

You are right. Setting AllowsEdits to "yes" fixed it.

Thanks.

BBM
 
Back
Top