On Reports.....

[Proaccesspro]

Can A Report Have Multiple Control Sources??

[Stewart Ross]

Can A Report Have Multiple Control Sources??

Hi Proaccesspro. Are you referring to the recordsource of a report? If you are, the recordsource can be changed or set under program control (e.g. to an SQL statement built at run-time in response to choices on a user form). If you are referring to the set of controls in the report, these are either bound to the fields of the recordsource (in which case they can't have multiple sources) or are unbound values calculated from within the report (in which case their values can be set or changed under program control as the report runs).

Let us know what you really mean...

-Stewart

[NeoPa]

Please look in POSTING GUIDELINES: Please read carefully before posting to a forum and consider rewording your question or adding extra relevant information. As it stands I'm afraid, it's too unclear.

ADMIN.