apply a filter in a report / subreport

  • Thread starter Thread starter PeterK
  • Start date Start date
P

PeterK

I have a report with a sub report. The report has among other things a
summary of records prior to a given date. The sub report has detailed
records after that date.

Report and sub report currently work based on a fixed date in the underlying
queries. But the date will vary so I want to use a prompt form. I don't
know how to apply a filter in this situation. I don't know if OpenArgs
relates to a subreport. I tried putting a statement in the Filter line of
the property sheet but that didn't do anything. Any help... much appreciated.
 
PeterK said:
I have a report with a sub report. The report has among other things a
summary of records prior to a given date. The sub report has detailed
records after that date.

Report and sub report currently work based on a fixed date in the underlying
queries. But the date will vary so I want to use a prompt form. I don't
know how to apply a filter in this situation. I don't know if OpenArgs
relates to a subreport. I tried putting a statement in the Filter line of
the property sheet but that didn't do anything. Any help... much appreciated.
Click to expand...


Filtering a subreport can be done by using a form with an
unbound text box where users can enter the parameter. The
form would also have a button to open the report.

With this lind of arrangement, the parameters in both record
source queries fould look like:
Forms!theform.thetextbox
 
Back
Top