Filter by Form

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.
 
V

Van T. Dinh

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

Filter by Form not working 3
Filter subform using combobox on main form 1
Expression is typed...... 2
How to always get the top level form reference, when calling from any subform/subform... 0
Mimic Split Form with Two Subforms 0
Filtering multiple subforms pulling from same query... 3
Subform of subform not being linked 3
Filtered form not using query 3

Top