Filtering Based on data from Subform

  • Thread starter Thread starter PJ
  • Start date Start date
P

PJ

Hi All,

Is it possible to filter records from main form by selecting data from
subforms? Please give me some hint. Thanks in advance.

Do I have to build a search function or is there a simple way?

Thanks.
 
Thanks Jeanette,

The filtering works now. I also have a clear filter button and coded like
this:

cboFilterSub.value = Null
me.Requery

This clear button works fine for other combo in the main form. But for this
subform filter based on the code from the link below, it only clear the
value. I cant get my query to requery to null criteria. Please give some
guidance. Thank you
 
I don't know if this is good coding or not, but in the clear filter button,
i put this code below and everything is working now. Thanks.

me.recordsource = "qryMain"
 
Great - just what was needed.

You could also have put something like
Me.FilterOn = False

Jeanette Cunningham
 
Back
Top