Unable to find Form

[excellenthelp]

Hello.

I wrote a code and this line keeps getting highlighted in the debugger. I am trying to figure out how to fix the form reference... Can you help me?

cmd.CommandText = "SELECT AccessLevel FROM tblEmployee " _
                        & "WHERE UserName = '" & Forms!frmMainMenu!txtUserName & "'"

Does it have to do something with dimming an object and setting an object to nothing between two different forms?

Help...

[excellenthelp]

Ah... the form (frmMainMenu) has to be open while opening the other form with the code.

Is there anyway I can do this with the form (frmMainMenu) either open or closed?

Thanks!

[Missinglinq]

...Is there anyway I can do this with the form (frmMainMenu) either open or closed

You can only reference a Control on a Form if that Form is open.

You're using Access 2013, so you could use TempVars to assign the user's name to a global variable and then use that in your reference.

Linq ;0)>