closing DB on exit of report

[eclecticbmxer]

I'm not much of a programmer and I was wondering what the best way would be to close a database by exiting a report. I can't find it in any of the Access books we have here, but I'm pretty sure there's got to be a simple way of doing it.
Thanks!

 

[neileg]

In the Properties box for the report, select the OnClose event and create either a macro or some VB code to invoke the Quit command. This will exit Access subject to some choices you can specify. Look in the help files for Quit. Writing a macro to achieve this is easy with the help provided. Writing a fragment of VB code is more elegant, but more daunting if you've never done it. If you are a real beginner, write the macro first, and then attach it to the OnClose event.

 

[eclecticbmxer]

Thanks a lot! That worked perfectly