Forms and Report Coding

J

Jeff

I click on cmdPrintRMAwReturn on frmMainSwitchboard to open
rptRMAShippingFormNoReturn, which is coded as follows:

Private Sub Report_Close()

DoCmd.Close acForm, "frmFindRMANoReturn"

End Sub
Private Sub Report_Open(Cancel As Integer)

DoCmd.OpenForm "frmFindRMANoReturn", , , , , acDialog

End Sub

This opens frmFindRMANoReturn and the user inputs the RMA#, clicks
cmdPreviewRMANoReturn, which is coded as follows:

Private Sub cmdPreviewRMANoReturn_Click()
Me.Visible = False
End Sub

The report opens in Print Preview to the specific record, and
frmFindRMANoReturn closes as soon as cmdPreviewRMANoReturn is clicked.
However, frmMainSwitchboard closes at the same time. How can I keep
frmMainSwitchboard from closing?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top