Design View Close Event

's Computer Specifications

I have a MS Access 2003 application and the users need the ability to design
their own reports. I have 3 popup, modal forms...frm_main_menu,
frm_administration and frm_reports. On the frm_reports form I have a command
button with the following code:
DoCmd.RunCommand acCmdNewObjectReport
DoCmd.Close acForm, "frm_reports"
DoCmd.Close acForm, "frm_administration"
DoCmd.Close acForm, "frm_main_menu"
This opens the new report wizard and closes all the open forms.
My problem is after they are done creating the new report and closing the
design view I would like to be able to automatically reopen the form
frm_main_menu.
Is their a way to do this? Thanks.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Form close events and design view	Jeff Hunt	Microsoft Access Form Coding	4	7th Aug 2008 05:06 PM
On close, report goes to DESIGN view	=?Utf-8?B?WFA=?=	Microsoft Access Reports	2	19th Jun 2007 07:47 PM
Switch to Design View without going off event handler	=?Utf-8?B?Y2xhcmE=?=	Microsoft Access Forms	1	16th Mar 2007 02:01 AM
On close switching to design view	=?Utf-8?B?bW5kaXBwZXI=?=	Microsoft Access Form Coding	0	8th Dec 2003 03:01 PM
Can't Design View or close form, or close Access	Bradley C. Hammerstrom	Microsoft Access Forms	1	23rd Sep 2003 07:23 PM