Method or data member not found error

[mose Mbugua]

I'm trying to make a username and password form in access 2007. After keeing in the below code, an error message showing "Method or data member not found" what might be the cause?

Private Sub Command5_Click()
Username.SetFocus
If Username = "staff1" And Password = "staff1" Then
MsgBox "Access granted", vbInformation, "school system2"
MsgBox "Welcome", vbInformation, "school system"
DoCmd.Close
DoCmd.OpenForm "School_system"
Else
MsgBox "Access denied Please enter your username and password"
else if
End Sub

[NeoPa]

Line #10 says else if instead of End If.

Please read Before Posting (VBA or SQL) Code. This gives tips that will help you so much you won't even have to ask many of the questions you might otherwise need to ask.

[mose Mbugua]

i'm trying to make a username and password form in access 2007. After keeing in the below code, an error message showing "Method or data member not found" what might be the cause?a yellow highlight appears on line 1

Private Sub Command4_Click()
Username.SetFocus
If Username = "staff1" And Password = "staff1" Then
MsgBox "Access Granted", vbInformation, "school system"
MsgBox "Welcome", vbInformation, "school system"
DoCmd.Close
DoCmd.OpenForm "School system"
Else
MsgBox "Access denied. Please enter your username and password"
End If
End Sub

[NeoPa]

If the highlight is on line #1 then you need to revisit the link I pointed you to in the first post. It means your code is invalid and won't compile. The link tells you how to proceed.