Hold VBA execution until form closes

[Duncs]

I have a form with an OK button, which shows an error message. (I
used this rather than the MsgBox, as I wanted more control over what
is displayed.)

What I need to know is, how do I hold the execution of the VBA code
until the OK button is clicked?

TIA

Duncs

 

[Ken Snell [MVP]]

Open the "OK button" form in Dialog mode; all code stops except for the code
running in that form until that form is closed or made invisible.

 

[Duncs]

Cheers Ken.

Open the "OK button" form in Dialog mode; all code stops except for the code
running in that form until that form is closed or made invisible.
--

        Ken Snell
<MS ACCESS MVP>http://www.accessmvp.com/KDSnell/







- Show quoted text -