Checking Form's Open Property

[JoeTekTips]

Pretty simple question, sorry if this is a little too simple;

How do I check the open propery of a form in an if statement? I need something like this;

if( frmJobTicket isOpen = true)
'do this
else
'do this

Thanks,
-Joe

 

[PHV]

Which VBA ?
For access:
If CurrentProject.AllForms("frmJobTicket").IsLoaded Then

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[JoeTekTips]

Yes, is Access VBA.
The code posted worked great.
Thanks,
-Joe