apply a filter in a report / subreport

[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.

 

[Marshall Barton]

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.

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

 

[aaron.kempf]

I usually store all my variables _IN_ a table instead of passing them
around