Printout is printing unload forms??

action

Registered User.
Local time
Today, 13:37
Joined
May 29, 2003
Messages
89
I have some code that I have used printout in for the 1st time. It prints the active report fine but then also prints the form "FRMmainboard" afterwards(which is NOT open). If I comment it out it still does it so I am confussed. A number of othe forms have been opened and closed since FRMmainform was last used, I 1st thought It may have been a " hangover" in the memory, if such a thing could occur I am not sure. Can anybody explain why this may be occuring?


This is the end of the code....

DoCmd.OpenReport "RPT CashDeclareTempPrint"
DoCmd.PrintOut acPages, 1, 1
DoCmd.SetWarnings True
DoCmd.OpenForm "FRMMainboard"
 
action said:

DoCmd.OpenReport "RPT CashDeclareTempPrint"
DoCmd.PrintOut acPages, 1, 1
DoCmd.SetWarnings True
DoCmd.OpenForm "FRMMainboard"


DoCmd.OpenReport "RPT CashDeclareTempPrint"
DoCmd.PrintOut acPages, 1, 1
DoCmd.Close "RPT CashDeclareTempPrint"
DoCmd.SetWarnings True
DoCmd.OpenForm "FRMMainboard"
 
no this did not work. I have even specified a close for the FRMmainboard before the printout just to be sure it is not open.

anymore suggestions?
 
I never use the PrintOut method so I'm guessing that it's printing the active object which in this case is your form. You might try use the SelectObject method to select the Report
 

Users who are viewing this thread

Back
Top Bottom