Question Hide a form behind a report

[mm07nkb]

Hi

I have a modal form with a button on it to run a report.

When I press the button I want it to show the report and hide the modal form behind it.

How do i do this???

Thanks for the help in advance!!

 

[Taruz]

Hi..

Private Sub Report_Close()
[COLOR="DarkSlateGray"]Forms!form_name.Visible = -1[/COLOR]
End Sub

Private Sub Report_Open(Cancel As Integer)
[COLOR="DarkSlateGray"]Forms!form_name.Visible = 0[/COLOR]
End Sub

Use these commands, the report is opened and closed events..

 

[mm07nkb]

Thanks do I put these in the code builder in the form or report?

Sorry new to acces still learning!!

 

[Taruz]

let I briefly describe..:

Report / Properties / Event Tab / On Open (Click [...] button) / select Event Procedure / paste code..:

Forms!your_form_name.Visible = 0

Do the same for other events..

 

[mm07nkb]

Thank you so much