Filter by Form

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

Guest

Hi,

I have 2 subforms within my main form. Both subforms are the exact same.

I want to filter the same field within each subform. The field's data can
either be in or out. I am using the filter by form and select "In" on one
subform and "out" on the other subform. This filters the subforms and I get
one that is sorted by in and the other by out.

My problem is how do I save this filter so that everytime someone opens this
form the items with be sorted accordignly.

Thanks.
 
Since your criteria are fixed for the Subforms, you can simply include the
(selection) criteria in the RecordSource for each Subform.
 
Back
Top