report subform print control

[Evets Htims]

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?

[Larry Linson]

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?