I have a combo box that I have placed on a form. The values come from a pass-through query. The combo box populates with the correct values but it will not allow me to select one. As an experiment, I created a new, blank form. I created the same combo box on it. It works correctly - it populates with the correct values and allows me to select one. If I copy
that same combo box to the form I want it on, it stops working.
The form that it does NOT work on is a "switchboard" form for the front end to the data. I cannot find a "Do Not Allow Combo Boxes To Work" property on the form :).
If more backstory is required...
I'm working with data described here
. Each Access file in question has got many excellent forms and reports that are beyond my skill level to create. When the data from all of these individual Access files is finally put in a SQL database, I am simply going to modify the underlying queries to query against the database for a particular shift. I am putting a combo box on the switchboard form to allow the user to select the shift for which they wish to see data. That is the combo box that populates but does not allow selection.