By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,105 Members | 2,560 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,105 IT Pros & Developers. It's quick & easy.

report subform print control

P: n/a
This is Access 2003. Have a report that includes three subreports
stacked on top of one another (they display order items). In the
report On Open I build a recordset (to get a value from a foreign
table that determines which of the subforms is used to preview the
items) and On Activate I run a case select that sets visable =
true/false for each subreport. This displays and prints fine from a
preview. If I open the report directly to print it prints all 3
subreports, apparently skipping the On Activate.
So my question is where can I run my case select when opening a report
in Print without preview?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You can execute code in the Open event, or you can execute it in each
record in the Format or Print events -- these fire whether you are in
Preview or in Print. I generally prefer the Print event because the
Format event may fire many times. It may seem a waste to execute the
code for each record, but unless it is very, very, very complex,
you'll never see the extra time it takes.

Larry Linson
Microsoft Access MVP

si*******@yahoo.com (Evets Htims) wrote in message news:<8b**************************@posting.google. com>...
This is Access 2003. Have a report that includes three subreports
stacked on top of one another (they display order items). In the
report On Open I build a recordset (to get a value from a foreign
table that determines which of the subforms is used to preview the
items) and On Activate I run a case select that sets visable =
true/false for each subreport. This displays and prints fine from a
preview. If I open the report directly to print it prints all 3
subreports, apparently skipping the On Activate.
So my question is where can I run my case select when opening a report
in Print without preview?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.