Is there a way to cancel the form from Loading if certian condition is not met.

[pedie]

Hi, I want to know of a way to cancel the form from Loading if certian condition is not met.

[/FONT]
[FONT=Courier New]Private Sub Form_Load()[/FONT]
[FONT=Courier New]if certian condition is met in table then
'open it
else 
 Cancel being opened
end if
End Sub

Is there anything like that?
Thanks for helping!

 

[Montez659]

I tried messing around with Cancel = True but that didn't work. What about having the If...Then statement in whatever procedure that you are using to open the form? Have it check before the form even tries to load, is that an option?

 

[boblarson]

You need to check in the OPEN event of the form so you can use

Cancel = True

However, the recordset is not loaded yet so you would need to use another method of checking (like a DCount to see if there are records). You can actually do this BEFORE you even attempt to open the form and ONLY open the form if there are records which match the criteria. Then you don't need to cancel the open because you never opened it to begin with.

 

[pedie]

Thanks again Bob for quick answer, this is connection to the "Public variable" 'm trigerring on my startup form 'm opening...if AccessX <> true then i want to cancel it from being opened....

I used this and works perfectly so far!!!


May I also ask what's the difference between close,load
and also Close and unload...?
Kind of confusing now...

Thanks again.

[/FONT]
[FONT=Courier New]Option Compare Database
Private Sub Form_Open(Cancel As Integer)
If AccessX = False Then
Cancel = True
End If
End Sub

You need to check in the OPEN event of the form so you can use

Cancel = True

However, the recordset is not loaded yet so you would need to use another method of checking (like a DCount to see if there are records). You can actually do this BEFORE you even attempt to open the form and ONLY open the form if there are records which match the criteria. Then you don't need to cancel the open because you never opened it to begin with.