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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First Subform record gets modified when closing form 3
Filter by Form not working 3
Main Form and two Subforms 2
Performance question 4
Access Daily Entry with multiple entries per field 0
Filter subform using combobox on main form 1
Which is faster? 6
Filtering a main form based on a sub-form 6

Back
Top