In the Form_Load event, load the form's Top, Left, Height, and Width settings from the user registry via the GetSetting function.

In the Form_Unload event, save the form's Top, Left, Height, and Width in the user registry via the SaveSetting statement.

The next time the form is opened, it will open to the same size and location as where you saved it, assuming there is enough space on the Access canvas.

Size and place the form where you want it (relative to the top left corner of the screen).

To control exactly where and how big a form is when it opens on-screen, you can position the form and save it in Design View. You can use variations of the following form window positioning properties ( WindowLeft, WindowWidth, WindowTop, WindowHeight) to align any two windows relative to each other, but opening a child window to the immediate right of a parent window is the most common scenario in my experience. To display the newly opened form side-by-side with the active form, we can use the active form's Width and Left properties to calculate the Right and Down arguments of the MoveSize method: Dim Right As Integer, Down As Integer

After the DoCmd.OpenForm line in the calling code.

This line of code can be placed in one of several places: Use the DoCmd.MoveSize method to relocate the form to the top left corner of the canvas by setting the Right and Down arguments to 0.

Set the form's AutoCenter property to True:

Techniques Listed By Form Open Location Open in the Center of the Screen Here are six techniques you can use to control where forms appear. To set the 'Document Window Options' go to File > Options > Current Database. If you use Overlapping Windows (see screenshot below) in your Access application, you need to think about where you want each form to appear when the user opens it.

Windowtop key