Shortcut or Command Buttons On Reports

[stu_C]

Hi all
on the database when a user enters database all the tool bar disappears etc which we want.

everything seems to work great but the only problem we have now is when a user views a report as a Print preview they cannot close it down as there are on close buttons.



is there anyway we can do this without the tool bar going back either with a command button that they click or a keyboard shortcut to close the window down?

[ketbdnetbp]

You might be able to put VBA code, like this, behind a button on a form...

DoCmd.Close acReport, "YourReportName"

See if that produces the desirable results.

All the best,

Jim