Print / Export not displaying information

[neshev]

Hi Guys,
I have a statistical analysis summary report that calculates data using SQL
code on the opening of the report. the data is then displayed with the use of
list boxes on the report. The problem that i have it when the user attempts
to print or export the report from the form the report prints but the code
does not execute and so the list boxes are empty. if the user views the
report on screen and right clicks and chooses print etc, it will work fine .I
tried to open the report before using the code to print it but this does not
work, any sugestions?

thanks

Neil