Full Version: Access Forms and Reports
UtterAccess Forums > Microsoft® Access > Access Forms
I have a Front end Menu with buttons for users to use.
ome buttons drive reports on a preview basis, but the report opens behind the menu form and I cant be seen without closing the menu.
Is there a way of showing the report in front of the menu? and then when printed return to the menu for further selections?
you can do a
ocmd.minimize line of code prior to the opening of the report,
DoCmd.OpenReport "yourreportnamehere", acViewPreview
then on the closing of the report do a
DoCmd.OpenForm "Yourformnamehere", acNormal, , , acFormEdit, acWindowNormal
In the form POP UP properties put NO.
As well as Johns suggestion, you can also hide the main menu with

Docmd.OpenReport "YourReportName", acViewPreview
Me.Visible = False

and in the Close event of the report

If CurrentProject.AllForms("NameOfMainMenuForm").IsLoaded Then
Forms!NameOfMainMenuForm.Visible = True
End If
many Thanks It works a treat
You're welcome. Glad we could help............
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.