got any sample code you can post?
Printable View
got any sample code you can post?
Sample code
If de.conRep.State = adStateClosed Then de.conRep.Open
If de.rscmdReport1.State = adStateClosed Then de.rscmdReport1.Open
If I replace rscmdReport1 with rscmdReport2 it works. There seems to be something wrong with rscmdReport1 but I can't find it.
rscmdReport1 is a recordset hanging off the conRep connection as is rscmdReport2.