Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Close a report like forms
- Thread starter helmi
- Start date
Paste the following code into a module
Function CloseActiveReport()
On Error Resume Next
DoCmd.Close acReport, Screen.ActiveReport.Name
End Function
Create a custom menu, toolbar or button (View-Toolbars-Customize)
Attach the function to it (Right click the button and choose Properties, then in OnAction box type 'CloseActiveReport'.
Whenever you have a report open, you can close it by clicking the button...
Good luck
![[pipe]](/data/assets/smilies/pipe.gif "[pipe] [pipe]")
Daniel Vlas
Systems Consultant
Function CloseActiveReport()
On Error Resume Next
DoCmd.Close acReport, Screen.ActiveReport.Name
End Function
Create a custom menu, toolbar or button (View-Toolbars-Customize)
Attach the function to it (Right click the button and choose Properties, then in OnAction box type 'CloseActiveReport'.
Whenever you have a report open, you can close it by clicking the button...
Good luck
Daniel Vlas
Systems Consultant
- Status
Similar threads
- Locked
- Question
