Oct 15, 2006 #1 MaggieLeatherman Programmer Joined May 9, 2004 Messages 59 Location US What code do I use to find out if a form is open. I need to use this information in an IF statement... Thanks, Maggie
What code do I use to find out if a form is open. I need to use this information in an IF statement... Thanks, Maggie
Oct 15, 2006 #2 PHV MIS Joined Nov 8, 2002 Messages 53,708 Location FR A starting point: If CurrentProject.AllForms("yourForm").IsLoaded Then MsgBox "yourForm is open" End If Hope This Helps, PH. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886 Upvote 0 Downvote
A starting point: If CurrentProject.AllForms("yourForm").IsLoaded Then MsgBox "yourForm is open" End If Hope This Helps, PH. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886