Report does not print at all

[romh]

Hi. I have a form that processes orders and from there calls a report when it is time to print the order. I am calling the report 4 times, one after the other in order to print 4 separate copies of the order. In actuality it calls 4 separate identical reports, one after the other.
I use the following from vba
DoCmd.OpenReport ReportName:="Invoices", WhereCondition:=condition
DoCmd.OpenReport ReportName:="Invoices2", WhereCondition:=condition
DoCmd.OpenReport ReportName:="Invoices3", WhereCondition:=condition
DoCmd.OpenReport ReportName:="Invoices4", WhereCondition:=condition

This was working fine for a couple of weeks, but now I get the following error from the On Error handler:

Object doesn;t support this property or method

What could be happenning, because after the error, it simply doesn;t print. COuld it be that the 4 successive DoCmd.Openreport commands are corrupting the software?



Thanks

 

[romh]

Actually I figured it out. It has nothing to do with printing

I had a recordset clone on the forms recordset, and was trying to use a Find command on that recordset. That is not allowed, so I changed it to a Findfirst command

Thanks

But what do you guys think about opening 4 reports one after the other? Will it get corrupted eventually, or is that not a problem. I ask this because I have had printer issues with Access in the past where a certain printer's driver has to be re-installed every week.

Thanks