IF (form is open) THEN??

[ChrisHaynes]

Hi there, I don't know the expression to say

IF a form is open THEN

Can anyone help?

Thanks

 

[RoyVidar]

There is a search facility here (advanced search at the top of the page), which sometimes gives results. Also a read at one of the "how to get the most out of the membership" faqs, can be recommended, for instance faq181-2886.

For this

[tt]if currentproject.allforms("frmMyForm").isloaded then
' form named "frmMyForm" is open
end if[/tt]

Roy-Vidar

 

[ChrisHaynes]

Thanks RoyVidar, that works brilliantly. I tried looking on some access pages but couldn't find the solution.

Thanks again for the answer.

Chris.