Filtering Data in Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a FORM from which i am opening another form that has SUBFORM in it.
I want to use values from the 1st form to filter data in the SUBFORM.
I can easily filter data in the Second form, but i can't seem to make it
work, to filter data in the subform.
Can anyone help.
 
Well i am using DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria
Where the stLinkCriteria is SQL statement. I can seem to find a way to
reffer to a control on the Subform.

I am not sure if this is possible at all,I am opening Form B (i can refer to
the controls on FormB). But i am trying to open Form B (using DoCmd.OpenForm)
and to refer to the controls on another form.
 
So you have FormA that opens FormB that contains a subform...

You'll have to include a reference to the controls on FormA as part of your
Record Source for the subform.
 
Back
Top