automation error?

[Guest]

Hello,

I am learning Access 2003 as I go, and thought I had got the hang of Macros
until this. I designed a macro for a command button that previews a report
corresponding to the current record on a form. Everything was working fine,
but for some reason it is no longer working. When I press the button I get
"Automation Error" which goes on like this:

Macro Name: ResultsfromMacro.Preview
Condition: True
Action Name: OpenReport
Arguments: Results, Print Preview, , [Protocol
#]=[Forms]![ResultsEntry]![Protocol #], Normal

I have tried several things, including inspecting the code (looks ok to me),
rewriting the macro and creating an entirely new Macro. All my other Macros
in this DB work fine, and another database I have has the same Macro and it
is still working. What the heck is going on?

 

[Guest]

Followup

I just tried to open the Report from the Database window and I get the
automation error again - so the problem must be with the report and not the
code. Can anyone tell me why there is a problem?