I have a single form that has two combo boxes. One of these is [Current Facility] and one is [Current Room]. I have been trying for many unsuccessful hours to come up with a way to fillter the [Current Room] based on the selection that is made for [Current Facility]. The values for [Current Facility] are determined based on a table Facilities and the values for [Current Room] are based on a table Rooms that link the facility to the room.
Can someone please help me with a solution to this? Right now, the [Current Room] combo box displays all 150 rooms. This is a problem because it could mess up reporting if people select one facility and a room that is not in that facility.
I thought it would be simple to have the [Current Room] combo box be filtered by what the user selects in the [Current Facility] box.