Filter problem

  • Thread starter Thread starter Tony Williams
  • Start date Start date
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
 
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.
 
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
 
Back
Top