Form Error 2450 - Form Not Found

[vivalanoah]

Hello everyone! This is my first post - this problem has been driving me up a wall.

I am relatively new to Access and VB. I am trying to create a log-in system that assigns a security clearance to each user and then restricts access to certain forms and reports based on security clearance. Right now, I have set up the log-in system - that seems to work fine. But when I try to lock the form based on security clearance, I get the 2450 - Form Not Found - error.

The code I am using on the form is as follows:

Private Sub Form_Open (Cancel As Integer)

If Forms!frmLogin!cboUser.Column(4) <> 1 Then
MsgBox "You do not have access to this form", vbOkOnly
DoCmd.Close acForm, "formname"
EndIf

End Sub

I appreciate any help you can give!

 

[rzw0wr]

The form is not open yet as you think of it as being open.

http://msdn.microsoft.com/en-us/library/ff196808.aspx

The above are the form events on open.

This link is for form events.

http://msdn.microsoft.com/en-us/library/jj714836.aspx

Dale