Hide Current Form When Open another Form

[a_20120]

Hi,
I have an Access form with four command buttons that display specific forms using the DoCmd.OpenForm. I want to hide the main form whenever one of the four buttons is clicked on and then restore the main form when the user closes the form opened by the command button.

 

[AndySuk]

Hi

You can hide the form but I think that it may be more memory-effective to close it using

DoCmd.Close acForm, "put the name of your form in here"

Not sure about the ability to hide...i can do it in excel(!) but you can make the form invisible using

Forms!("put the name of your form in here").visible=false

You can use the same command and change it to "=true" when you want it back again.

A

 

[Rich]

Toggle the .Visible property of the form