OpenReport Action Cancelled in Access 2003

[tmc]

I have a database created in Access 2002 with a button on
a form which opens a report when clicked. It works fine
on all my machines running Access 2002 but we have a new
laptop running Access 2003 and when the button is clicked
we get an error message saying "OpenReport Action is
cancelled". Any ideas why? Is it a version difference
in Access?

I used the Button Wizard to create the code to open the
report.

 

[TC]

If the report Cancels itself, the OpenReport will get that error,
unless it suppresses it with an On Error statement. So, maybe the
OpenReport code does *not* check for that error, and there is
something about the *data* on the A2003 laptop that causes the report
to Cancel itself. Perhaps there is no data for the report (on that
laptop)?

HTH,
TC

 

[Guest]

I've learned a little more. When I open the database on
the machine running Access 2003 I can modify or run all
the objects (forms etc.) as expected. However, although
the reports are listed on the Reports tab, I cannot open
or design them. If I click on them the hourglass appears
for a moment and then goes back to the cursor. Any ideas?