OpenReport Action was Cancelled when attempting to Preview a repor

[Chuck W]

Hi,
I have Access 2003 on a Windows XP PC that I am modifying for another user
who also have Access 2003 on Windows XP. She has been using the database for
several years. There is a table called tblPatients and a series of queries
used for reports that I created. I have a report called frmReports which has
two text boxes (txtStartDate and txtEndDate). She plugs in a date range
(i.e. 1/1/09 in the txtStartDate box and 9/30/09 in the txtEndDate box). In
my query that runs various reports I have a field called ConsultDate that has
the following code:

Between [forms]![frmReports].[txtStartDate] And
[forms]![frmReports].[txtEndDate]

I then have several reports on the frmReportss form below the text boxes
which are supposed to run and provide information based on the date range.
It works perfectly on the Access on my PC but not on hers. She gets an error
message that says "The OpenReport action was cancelled". She does have a
printer installed by the way since that is sometimes the problem. There is
data that gets returned when I run the reports. I did a compact and report
but it did not solve the issue. Can someone help?

Thanks

 

[S.Clark]

If you can figure out what triggers it, you can trap and suppress the error
in code.

On Error goto proc_err

<Do whatever>

Proc_Err
if err.number = [####] then
resume
else
msgbox err.description
exit sub
end if