VBA - reopen main form after closing the print preview

[namu23]

Hello,

I have a form named "Order Request Menu" with a command button that prints the current record that appears on the Order Request Menu form. The vba code i've put on the button (Print Record) is:

Private Sub Command55_Click()


Me.Visible = False


DoCmd.OpenReport "Print Order Request", acViewPreview, , "[ID] = Forms![Order Request Menu]![ID]"




End Sub

What the code from above does is when i clicked the Print Record, it will print preview the current record and hides the main form. Now, my problem is how can i reopen my main form after i close the print preview?



Any help or suggestion to revise my code will be much appreciated

Thank you.

* Sorry, this post has been edited as i forgot to mentioned that the Order Request Form is POP UP and MODAL.

[pbaldy]

Make the form visible in the close event of the report.

[namu23]

Thanks pbaldy, yes that is what i'm trying to do but i don't know how to do it. Can you please guide me how to trigger the close event on the report?

And here's what i did:

On the acViewReport, i can put a close button to reopen the form and close the report. But on the acViewPreview, the button will be gone and there is no way i can go back to the form unless i reopen it manually. I want to apply this on the acViewPreview and not going back to acViewReport to close the report and reopen the form automatically

[namu23]

Done!

i need to add this code WindowMode :=acDialog before the me.visible = true

Private Sub Label56_DblClick(Cancel As Integer)

Me.Visible = False
DoCmd.OpenReport "Print Order Request", acViewPreview, , "[ID] = Forms![Order Request Menu]![ID]", WindowMode:=acDialog
Me.Visible = True


End Sub

[pbaldy]

Glad you got it sorted. The close event would have been triggered by the user closing the report in preview mode. You didn't need a button.