pop up: delete records

[JIM.H.]

Hello,
I have a main form and I want it to stay maximized all the
time, I do that by using DoCmd.Maximize on activate
trigger. My problem is I have other small forms and I do
not want them maximized when they are called through a
button on the main form. I used pop up "yes", it works
fine that way but I could not delete records in the opened
form, it says record is open.
Any suggestion?
Jim.

 

[fredg]

Hello,
I have a main form and I want it to stay maximized all the
time, I do that by using DoCmd.Maximize on activate
trigger. My problem is I have other small forms and I do
not want them maximized when they are called through a
button on the main form. I used pop up "yes", it works
fine that way but I could not delete records in the opened
form, it says record is open.
Any suggestion?
Jim.

Instead of using Pop-up, code the form's load event:
DoCmd.Restore
Or.. if you only want this to open small when opened from another
form's command button, you can pass an OpenArgs argument from the
first form,

DoCmd.OpenForm "Form2", , , , , , "Hello"

then use the Load event of Form2 to read it.

Code the Load event of Form2:
If IsNull(Me.OpenArgs) Then
Else
DoCmd.Restore
End If

You'll need to maximize again when you leave this form (if that's what
you want).

 

[Guest]

Thanks Fred,
My problem is when we use docmd.restore in any form it
effects the main form too, is there any other way I can
open new form without maximized and without changing of
main form.
Thanks,
Jim.