I have created a database that displays this issue so I can show what I'm trying to do, as I'm not allowed to show the actual database I'm working on. The database opens with the Faculty form showing. The text boxes txtOffice and txtBuilding pull the room number (Office) and the Building from the tblDepartment as selected in cboDepartment and display them automatically. This form presupposes using Filter by Form to search. Clicking the New Search button opens the form in that mode and hides the button. It also hides txtBuilding and displays cboBuilding, which populates with the unique values from tblDepartment...or at least it's supposed to. What happens is that cboBuilding does show up but is not accessible.
In addition to making it accessible, I want to be able to code it to display the unique values of the field Building from tblDepartment, and I want those values to be able to use whatever value selected in cboBuilding in the Filter by Form process as a filter/search criteria.
I thought replacing the textbox-and-combo-box solution with a single combo box might work, but I found the combo box
inaccessible as well. This makes me think I've done something incorrectly in the setup of this control, but I can't find what in its properties.
Here's the database. I appreciate any help I can get on this.
11 Never Happen University Database.zip