ms Access Macro Help

[jeffrey159]

i tried using macro to locate it but doesn't work.
After logging in from "Login" Form it will open up a form "LoginMenu" with a list of buttons of Forms that i'm able to access to.

This Macro is in "LoginMenu" with a list of buttons of macro events
If [Forms]![Login]![cboUsername]="Admin" Then
Open Form
Form name: Club
View: Form
Data Mode: Read Only
Window mode: normal
End if

and after i try logging in to admin and click Clubs

Error: Microsoft Access cannot find referenced form "Login"

i don't understand why it can't find the form when it's located together there...

[meratigoerr]

Can you post the code you are using to open the form [LoginMenu]?

[jeffrey159]

Can you post the code you are using to open the form [LoginMenu]?

there's no code in LoginMenu, just buttons that i right-click > Build Event > marcro

[jeffrey159]

ah crap, sorry didn't read carefully and i can't edit post...

Private Sub cmdLogin_Click()
'Check to see if data is entered into the password box
If IsNull(Me.txtPassword) Or Me.txtPassword = "" Then
MsgBox "You must enter a Password.", vbOKOnly, "Required Data"
Me.txtPassword.SetFocus
Exit Sub
End If

'Check value of password to see if this
'matches value chosen in combo box


If Me.txtPassword.Value = DLookup("password", "tblUsers", _
"[ID]=" & Me.cboUsername.Value) Then
ID = cboUsername

'Close logon form and open loginmenu form


strLoginName = Me.cboUsername
DoCmd.Close acForm, "Login"
DoCmd.OpenForm "LoginMenu"

Else
MsgBox "Password Invalid. Please Try Again", vbOKOnly, _
"Invalid Entry!"
Me.txtPassword.SetFocus
End If

End Sub

[Charlie_B]

Are you absolutely sure that the form with your log in button is called "Login"? Try replacing this line:

DoCmd.Close acForm, "Login"

with this:

DoCmd.Close acForm, Screen.ActiveForm.Name

Edit: Alternatively, just right-click the form in the navigation pane, select 'Rename', and call it Login!

[jeffrey159]

Are you absolutely sure that the form with your log in button is called "Login"? Try replacing this line:

DoCmd.Close acForm, "Login"

with this:

DoCmd.Close acForm, Screen.ActiveForm.Name

Edit: Alternatively, just right-click the form in the navigation pane, select 'Rename', and call it Login!

DoCmd.Close acForm, "Login" << yeah it's called Login
isn't this a do command to close the current form "login" ??
what's wrong with that??

[meratigoerr]

Long story short. You've trying to reference a field from a form that's already been closed.
in your code for the login form you have the line.

docmd.close acform, "Login"

This closes the login form. Then you open the form "loginmenu" and run the code:

 if [Forms]![Login]![cboUsername]="Admin" Then

this code specifically references a form that you've already closed. You'll have to save the required field to either: 1. call your if statement before you close the login form. 2. save your user name to the newly opened form. or 3. save your username to a global variable.