I have a navigation form that has a subform that is a list of employees. One fields is a checkbox that says if they are active or not, when the form opens it gives a list of all active and non-active employees which is rather long, as a default i would like it to show only the checked employees (active ones) to shorten the list but also still have the ability to show the unchecked (not active ones) if needed by the drop down. is this possible?
Thanks
Thanks