DoCmd.OpenReport suddenly failing, macro OpenReport succeeds

[MattE]

This is weird.

This database has worked ok for years, now suddenly in some VBA code a
DoCmd.OpenReport is failing, the error handler there doesn't get hit,
but the macro that called that VBA function gets an Action Failed in
RunCode. If I open the report manually it succeeds, if I open it
directly from a macro it succeeds. At least a couple of different
places this happens.

Anyone else seen this?

 

[MattE]

One more thing, it only is a problem on one machine (WinXP SP2),
others WinXP SP2 machines are still ok.

 

[MattE]

And if the VBA code does a RunMacro which prints the report that
works, but if the VBA code does an OpenReport of the same report that
fails!