How can I print a report using criteria from a subform?

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

Guest

I've read every article I could and I haven’t found an answer that I
understand. I would like to filter records in a subform and then print a
report based on those filtered records. I believe I have to reference the
subforms (Child0) me.filter but I am not sure of the syntax.
 
AirgasRob said:
I've read every article I could and I haven’t found an answer that I
understand. I would like to filter records in a subform and then print a
report based on those filtered records. I believe I have to reference the
subforms (Child0) me.filter but I am not sure of the syntax.
Click to expand...


Depends on how you are opening the report. If it's a
command button on the subform, then you can modify the
command button's click event procedure's OpenReport line to
use the Filter property:

DoCmd.OpenReport ..., WhereCondition:= Me.Filter
 
Back
Top