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

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.