Filter form on open

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an employee database that has all current and past employees in it.
Presently when an employee quits on the main employee form (linked to the
tblemployees), one would put a check in the box separated, which then pulls
up another form to enter all their discharge information. I have it set for
all the combo boxes that they will exclude those where the field Separated is
Yes, to shorten the list.

Is there anyway to automatically load forms in a filtered mode so that when
the form opens, those that are separated are not shown (this would be based
off of the separated field in the employees table)? I made a filter and
thought I had everthing right for it, but everytime you close the form and
come back in, you have to reset the filter again.

Thanks
 
There are 2 (basic) options:

1. Use a macro with the OpenForm action and a filter
2. Use VBA OpenForm method with a FilterName/WhereCondition argument set.

[Search help for OpenForm for more details]
 
Back
Top