Set record Source in Sub Report

[Guest]

When (what event) is the appropriater time to set a record source for a sub
report.?

The Having clause of the select is based on the results of the query for the
main report.

Thanks

Lee

 

[Marshall Barton]

When (what event) is the appropriater time to set a record source for a sub
report.?

The Having clause of the select is based on the results of the query for the
main report.

Generally, the subreport should be filtered by using the
Link Master/Child properties.

To answer your question, the only place where you can set
a report's record source at runtime is in that report's Open
event. In the case of a subreport, it can only be done the
first time the subreport's Open event fires.

If you'll provide more details about what you are trying to
accomplish, maybe someone will be able to provide an
alterantive approach or at least a more specific answer.

 

[Guest]

Thanks Marshall. Your answer was just what I needed.

Lee