Open form in min view

[Bee]

Hi,

I have a form that has a button, when user presses that button another form is supposed to open in minium view. The problem is that: If my main form is maximized, the other form opens as max or the other form makes main form minimized.

I wonder if it's possible for the main form to remain maximized when the smaller form opens?

Regards,
B

 

[rborob]

change the other forms property to popup

 

[Tezcatlipoca]

As rborob says, you can use a popup property to make the sub-form smaller than the main form. If however, you want the sub-form to start minimized, there are two methods spring to mind:


Method 1: Use a Macro

Go into macros and hit 'New'. For the first row, setup an OpenForm command, then fill out the details/requirements of the form you want opened.
Now on row two add a Minimize command.
Finally, on your main form, just have the button which would normally open the sub-form just point to the macro you've created.


Method 2: Use VB script

Open your sub-form in design mode, then right click the title bar and select 'Properties'. Scroll down to the 'OnLoad' command and click in the box, now click the elipse (three dots) button on the right.
When the VB builder opens, simply enter the line DoCmd.Minimize where the cursor is flashing, then save.

 

[Bee]

Great, I managed to get it to work now.

Thanks,
B