Filter problem

T

Tony Williams

I have a form with a tab control which has two subforms. If I use the Filter
by Form option it doesn't seem to pick up criteria from the subforms. Is
there anyway to do this so that I can filter records on criteria based on a
control on the main form and a control on the sub form?
TIA
Tony Williams
 
A

Allen Browne

See:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html

The article suggests reassigning the RecordSource of the main form to it
only contains a matching record.

It is also possible to use a subquery in the form's Filter property, if you
are comfortable with writing those.
 
T

Tony Williams

Thanks Allen, I've looked at that and need time to get my head around it. if
I have problems I'll come back under a new thread with a specific problem
Thanks again
Tony
 

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

DLookup in Continuous form 0
Split form 0
First Subform record gets modified when closing form 3
Which is faster? 6
filtering a form based on the values of a subform 0
Populate main form from subform record 0
Unremovable horizontal scroll bar on subform 1
Tab control not working with queries 7

Top