Preview a report in a form

[MParkhouse]

I have a report that runs off a query, no input needed. I can run this report from a button but I would like to see it within a form so that the user can print it (or not) and use buttons to return to the menu form or exit.



Access 2016 on Windows 10.

Thanks in advance

[RuralGuy]

Doesn't PreviewReport give you those options?

[MParkhouse]

I can print preview the report from a button on my main menu but the report opens in what I call never, never land. It's not under the control of a form. I'm not sure what it would do if I weren't in the Access app. If I could show it within a form, then the user could choose other actions like print, return to the menu or exit via buttons on the form.

[Bulzie]

That's not needed, when it opens in preview mode, all of those options to print or Close(returns to the form) are in the ribbon bar. Or you could create a custom toolbar for reports, etc. Also I believe you can set Model property on the report to "Yes" so that you have to close the report before you can return back to the form.