DoCmd.Minimize not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to minimize Form 1 and then open Form 2. I think I have the syntax
right, and here's the code on my "submit" button on Form 1

=================================
Private Sub Enter_Survey_data_Click()
Dim stForm2 As String
stForm2 = "FRM - Step 2"

DoCmd.Minimize
DoCmd.OpenForm stForm2

End Sub
=================================

Form 1 is NOT minimizing, in fact it stays in front of Form 2 - any ideas?
I'd be fine with Form 2 "popping-up" over Form 1, but even with a SetFocus on
Form2 it's not working.....
 
(1) Does docmd.minimize take parameters? (I don't have Access here to
check) If so, try:
docmd.minimize acform, me.name

(2) Why bother anyway? If you open another form, it will generally open
on top of the calling form. Isn't that enough?

HTH,
TC (MVP Access)
http://tc2.atspace.com
 
For your 2 points:

1) Nope - doesn't take (or want/accept) any parameters
2) That's what I thought, but in this case Form 2 (the form that is called)
does NOT pop up over Form 1 (the calling form)

Thanks for the fast reply
 
Maybe the calling form has Popup=True, and the called form doesn't? If
so, make the calling form a non-popup form, or conversely, make the
called form a popup form also.

HTH,
TC (MVP Access)
http://tc2.atspace.com
(off for the night)
 
Thanks again for your help. I finally was able to make it "minimize" by
moving the minimize command to a different place in the code. Now the
correct form is open, the correct form is minimized, but the focus isn't on
the right form.... No big deal, thanks for your help.
 
Back
Top