Have a form appear in a certain part of the screen

[GeorgeJ]

Hello. I have a form, Form2, which I want to appear in a certain part of the screen. I want this to happen because I eventually want the form to be launched from code in another form (Form3)'s code file, and I want form3 to still be visible when form2 appears. I have been using design view on form2, but I have adjusted every format property which seems relevant, and I move form2 down to the lower left of the screen in Design View before I close it, but every time I double click on Form2 at the command screen it always appears near the center of the screen.



The normal command in VBA I use to launch a form is

DoCmd.OpenForm "Form2"

Is there a modified version of this command that I could use to have the form open in a certain part of the screen? If not, is there a way I could change Form2's properties to have it appear at a certain place on the screen when it opens?

Thanks in advance

[pbaldy]

The only thing that comes to mind is playing with MoveSize:

https://msdn.microsoft.com/en-us/lib.../ff197394.aspx

[JeffChr]

check your AutoCenter property for the form

[GeorgeJ]

Thanks.

I set AutoCenter to No, Movable to No, then in Design View move the window containing Form2 to the lower left of the screen, then close the window saving the changes made, then in command mode double click on Form2 ands presto, it opens where I want it to.

Problem (apparently) solved.

[pbaldy]

Glad you sorted it. I'll be curious to see if it works correctly on other user's computers.

[JeffChr]

me too (curious to see if it works correctly on other user's computers).