Stop Opening The Form

[Schlingel]

Hi!
Hope u all r doing well.
I need ur help once more, please. I have tried to find it in the forum but no luck.
I have a form and on_open event, which checks if the user has already wrote down his day plan. In this case the form must not open at all. What i could get is that the user get the error message...
Could u please help me with any idea, how i could stop opening form if the variable is equal 8 for example?
Thanks in advance as always

 

[gemma-the-husky]

in the open event (or it might be the load - one of the them has a parameter called cancel) - if you don't want it to open in the event just put


cancel = vbcancel
msgbox("Cant open etc.... ")
exit sub

tells access not to open it

 

[Schlingel]

Thanks again, gemma-the-husky, u saved me again...