471,071 Members | 913 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,071 software developers and data experts.

report subform print control

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
1 1645
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.

Similar topics

3 posts views Thread by bbdata | last post: by
4 posts views Thread by Henrootje | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.