On Close View/Print Report Return to Switchboard

[capndave]

After viewing or printing report I want close report and return to the main menu (switchboard). I have tried using a macro to open mainmenu on close and on deactivate properties of the report. The main menu appears when I select close on the report, but the report remains open as well.
Any suggestions would be deeply appreciated.

 

[ZmrAbdulla]

Forget the Macro and paste this code in the code window. Remember to change the "SwitchboardformName" to its original name

Private Sub Report_Close()
    DoCmd.OpenForm "SwitchboardformName"
End Sub

________________________________________________________________________
Zameer Abdulla
Visit Me
A person who misses a chance and the monkey who misses its branch can't be saved.