If you prevent inactive pharmacist names from being in the list, how do you ever search on them in the future? Recreate the form and its underlying query for a different purpose? Not me.
Consider a means of applying one list or the other - or the entire list of pharma's. An option frame with 3 buttons could provide such choice. 1 for active, 1 for inactive and 1 for all. I would probably disable the combo unless a user chooses one of the options, then enable it. Should work as long as there aren't conflicting form properties such as only allowing additions.
You could also open this form to the chosen search option, but user would have to close and reopen in order to change options.
Last edited by Micron; 09-25-2018 at 05:34 PM.
Reason: added info
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.