return to form

[rdw456]

I have a form with several command buttons to run reports. When I open the form I used the docmd.maximize and when I use the button to run the report it runs but when I close the report it returns to the form which is now sized not maximized. I want to have the form as it was before I opened the report. not sure why it is doing this.

Thanks in advance

Bob

 

[JHB]

Then try by setting the DoCmd.Maximize on the form's Activate event.

Private Sub Form_Activate()
  DoCmd.Maximize
End Sub

 

[rdw456]

Hello thanks for the tip it worked

Bob