Active Employees visible on form list (1 Viewer)

[Sym]

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

 

[theDBguy]

Hi. You could try setting the Form's Filter property in design view. For example:

Filter: [Active]=True
Filter On Load: Yes

When you view the form and want to see all employees, you can simply clear the Filter.

 

[MajP]

You could add on the main form three command buttons. Show All, Active, Inactive
for show all the code would be something like
me.subformcontrolname.form.filteron = false

for active
me.subformcontrolname.form.filter = "Active = True"
me.subformcontrolname.form.filteron = true

for inactive
me.subformcontrolname.form.filter = "Active = False"
me.subformcontrolname.form.filteron = true

 

[Micron]

I might do an option frame rather than 3 command buttons, but it's just another way of doing pretty much the same thing. All depends on what looks best to the designer, I suppose. A combo could work, but you would need to add the <All> option.