On close, report goes to DESIGN view

[Guest]

Using Office 2003 and Windows XP;

I have a custom toolbar for reports to control the app during print preview
mode. The program copies the "Close" button from the normal toolbar so the
user can close the report.

In another DB I use this same code and it runs fine; but in the current DB
I'm developing, when the "Close" button is clicked, the report switches to
DESIGN view rather than closing. There must be something I've missed, but I'm
too blind to see it. Can anyone please help me out?

Thanks much in advance.

 

[Rick Brandt]

Using Office 2003 and Windows XP;

I have a custom toolbar for reports to control the app during print
preview mode. The program copies the "Close" button from the normal
toolbar so the user can close the report.

In another DB I use this same code and it runs fine; but in the
current DB I'm developing, when the "Close" button is clicked, the
report switches to DESIGN view rather than closing. There must be
something I've missed, but I'm too blind to see it. Can anyone please
help me out?

Thanks much in advance.

That is what "close" will do if the report was in design view before you
changed to preview mode, but otherwise I have never seen that behavior.

 

[Guest]

Yes, your comment jogged my tiny brain and I remembered that I had switched
to design view to alter the record source of the report on the fly; once I
changed this technique it works fine; THANKS!