2003 Allow SourceObject Change?

[Guest]

Does Access 2003 permit coding to change a subreport's source object during
printing, according to the content of a particular field?

 

[Larry Linson]

"David Habercom" wrote

Does Access 2003 permit coding to
change a subreport's source object
during printing, according to the
content of a particular field?

Give it a try and post back here what you find. Trying it is about as close
to trivially easy as I can imagine.

Hint: Try putting the code in the Report's Detail Section's Print or Format
event.

While you are at it, do the same for Form and Subform. Put the code in the
Form's Current Event.

This isn't quite as simple as it seems, but there is a way to accomplish
what you want to do.

Larry Linson
Microsoft Access MVP

 

[Guest]

Actually, I don't have 2003, and this is really a purchase question. I have
2000 and have not found a way to change a report's source object on the fly.
But it sounds like 2003 will do it, which is a good reason for me to upgrade.
Am I correct?

Thanks.

David