Form sizing issue

[Beth]

In my database I have one form with a running list of students. When you
select a name from the list, I want it to open the students form to that
student's record as a dialog form so that I can have some code wait for the
student form to close before it runs.
The code is DoCmd.OpenForm "frmStudents", acNormal, , "StudentID =
Forms!frmStudents.StudentID", acFormEdit, acDialog

All that works fine except that when the Student form opens, it maximizes,
removes the toolbars at the top and even covers the Windows start bar at the
bottom of the screen. I have played with settings, but I can't get it to
maximize within the database frame, leaving the taskbar and toolbars.

What is the setting that I have wrong? Thanks!

Beth

 

[Marshall Barton]

In my database I have one form with a running list of students. When you
select a name from the list, I want it to open the students form to that
student's record as a dialog form so that I can have some code wait for the
student form to close before it runs.
The code is DoCmd.OpenForm "frmStudents", acNormal, , "StudentID =
Forms!frmStudents.StudentID", acFormEdit, acDialog

All that works fine except that when the Student form opens, it maximizes,
removes the toolbars at the top and even covers the Windows start bar at the
bottom of the screen. I have played with settings, but I can't get it to
maximize within the database frame, leaving the taskbar and toolbars.

What is the setting that I have wrong? Thanks!

AFAIK, What you did wrong was maximize the student form in
dialog mode. Dialog and popup forms are not confined to the
Access window.

Instead of using DoCmd.Maximize, use DoCmd.MoveSize to make
the form large, but not too big.