Minimize and Maximize code

[Gorio]

I'm looking for some simple code that I can put in a form for the "on click" event. All I want is for it to open a second form, maximize it, and then minimize the first form. If possible I would also like it to run a macro that loads some information on the second form between the minimize and maximize events. I'd appreciate any help that you can provide. Thanks

 

[Kenneth]

This is one way of doing it:

docmd.openform "Second Form", acNormal
docmd.Maximize
DoCmd.RunMacro "Name"
DoCmd.SelectObject acForm, "First form"
docmd.Minimize

I assume you already have made a macro that you want to use.