Really strange report problem!!!!!!!

[Marc Robitaille]

I have a strange problem. I have a form from wich a user can select a year
in a combobox. I set a variable to the value of the combobox. Than, the
user can click on the print button. The user will preview a master report.
It have 5 subreports in it and they are all base on the year from the
variable. In each subreport, there is a public sub that it is call from the
Activate event of the master report to populate all the textbox from the
subreports. On the screen, we can see all the values but when it is
printed, they all disapear.

Is there some one who have and resolve this problem
Thank you
Marc

 

[Steve Schapel]

Marc,

I don't think a report's Activate event occurs when you print it.

I would say the simplest solution would be to base the recordsource of
the subreports on suitably constructed queries, and bind the textboxes
to the relevant fields.

- Steve Schapel, Microsoft Access MVP

 

[Marc Robitaille]

The Activate event occur in the master report but not in the subreports.
That's why I call public sub, define in each subreports, in the Activate
event of the master report to fill the subreports. I can see all the
labels, textbox with the values in each textbox on the screen but when I try
to print it, only the labels, textbox with no values show up.