Open Form Based on Null Field Value

[Guest]

I'm trying to make a pop up form open based on the blank value of a field on
another form. Form1 has Field1 which if blank, will open the pop up Form2
when Form1 is first opened.
The help is greatly appreciated!!
Thanks,
PHisaw

 

[jleckrone]

Try a OnOpen or OnCurrent event for Form1. It would look something
like this:
If IsNull(Me.Field1) then
Docmd.OpenForm "Form2"
End if

 

[Guest]

Thanks for the quick reply and it worked, but I didn't think this through. I
have five other fields that have pop up forms based on whether they are
blank. So if "Field1" is not blank, but the other five are I'll have five
popup forms open on top of each other. This is a staged event. Field1 must
be completed and initialed before moving to Field2. I only want to show popup
form for Field2 when Field 1 is completed, but not Field3. Is there a way
that I can have only one at a time? Once again, the help is greatly
appreciated!!