Can't click selections in combo box

  • Thread starter Thread starter stephminn
  • Start date Start date
S

stephminn

I have a database with a form that creates a query from
the selected fields in a list/combo box. The query works
and all that is fine, but when the form opens (it opens
automatically when the database is opened), and you click
to view the drop down box and click on a list selection,
it won't select the item. However, if you close the
form, then open it again, you can then select from the
items in the list box. Seems like a bug in Access, but I
don't know how to get around it. Any ideas on how to get
around this bug, or fix it? I'd like to avoid having my
users close, then re-open the form in order for the list
boxes to work.
 
[email protected] said:
I have a database with a form that creates a query from
the selected fields in a list/combo box. The query works
and all that is fine, but when the form opens (it opens
automatically when the database is opened), and you click
to view the drop down box and click on a list selection,
it won't select the item. However, if you close the
form, then open it again, you can then select from the
items in the list box. Seems like a bug in Access, but I
don't know how to get around it. Any ideas on how to get
around this bug, or fix it? I'd like to avoid having my
users close, then re-open the form in order for the list
boxes to work.
Click to expand...

Sounds like the form is being opened Read-Only. What is the AllowEdits
property set to? Are you using code to open the form or did you set it as
the Startup form in Options - Startup? Can you change other controls on
the form?
 
Back
Top