-----Original Message-----
There's really no way to do this effectively other than to use api calls
into the print spooler using EnumJobs and monitor whether the job releases
from the spooler via a timer loop. To monitor the job you'd have to have
the report name as the print job name to look for in the spooler's jobs.
(Normally when calling EnumJobs you'd query on JobID which is created by the
spooler and sent back to the calling application, but since that isn't
available from Access in any way, you have to use the Job Name which is
normally the report name unless the report has a caption set, wherein the
job name would be the caption.)
HTH
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg
.