Set record Source in Sub Report

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

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
 
Lee said:
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.
Click to expand...


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.
 
Back
Top