Open and close form

[emir_w]

Hi, I'm a beginner in MS Access.

I've created a Form for Entry data and some reports. And I have created also a form as Main Menu which is contains of 2 buttons (entry data and report).

What I want is:
- When I click the button for entry, main menu form should be close and open the entry form.
- When finish from entry form, by clicking 'close' button in entry form, it close entry form and open main menu form automatically.

Same thing when I clicking or reports.


Thanks in advance.

 

[John Big Booty]

Have a look at the DoCmd.OpenForm method as well as the DoCmd.Close method

 

[alpertunga65]

Hi, I'm a beginner in MS Access.

I've created a Form for Entry data and some reports. And I have created also a form as Main Menu which is contains of 2 buttons (entry data and report).

What I want is:
- When I click the button for entry, main menu form should be close and open the entry form.
- When finish from entry form, by clicking 'close' button in entry form, it close entry form and open main menu form automatically.

Same thing when I clicking or reports.


Thanks in advance.

Hi Emir,

In easy way;

for the button for entry,
you can write;
DoCmd.OpenForm "Entry_Form"
DoCmd.Close acForm, "Main_Menu", acSavePrompt

Then try it for the other forms and reports. After clicking Close buttons on each form you turn back Main Menu.
For reports you can write it under "close" property of the report.

 

[missinglinq]

You'll want to omit the acSavePrompt in

DoCmd.Close acForm, "Main_Menu", acSavePrompt

This would make Access pop a warning, every time the Main_Menu form closed, asking if you wanted to Save any Design Changes that were made to the Form! While this is sometimes appropriate, it really isn't when you're talking about a menu Form, and would be aggravating as all heck to the users.

Linq ;0)>