pop up: delete records

  • Thread starter Thread starter JIM.H.
  • Start date Start date
J

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.
 
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.
Click to expand...

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).
 
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.
 
Back
Top