stuckincement
New Member
- Joined
- May 5, 2014
- Messages
- 26
Hi,
I have two combo boxes that I created that allow a user to filter data down to a specific record (First, facility, then department number). Department numbers can repeat by facility however I did set the row source to be based on the facility that was picked in the first combo box. This works fine for the first user selection but the next selection it does not follow the same logic and thus picks a random facility/department combo instead of the one picked by the user in the combo box.
How can I allow a user to make a second selection of facility, then department and it work as it did for their first selection?
Thanks,
I have two combo boxes that I created that allow a user to filter data down to a specific record (First, facility, then department number). Department numbers can repeat by facility however I did set the row source to be based on the facility that was picked in the first combo box. This works fine for the first user selection but the next selection it does not follow the same logic and thus picks a random facility/department combo instead of the one picked by the user in the combo box.
How can I allow a user to make a second selection of facility, then department and it work as it did for their first selection?
Thanks,