I thought I posted this yesterday, but I couldn't find my thread. Is there a function either in VBA or on the macro form that I can use that would return the name of the open form?
There may be more than one form open of course. consider something like:
Code:
dim frm as form
dim stropen as string
for each frm in forms
if frm.isopen then
strOpen=strOpen & ", " &frm.name
endif
next frm
if nz(strOpen,"")<>"" then
msgbox "These forms open: " & stropen
endif
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.