Show who you are logged in as?

[pr2-eugin]

surfrus, I think you still have not figured out what/how to do it.. What I think you have (based on your screencaps) is that the ID (which we have been talking about) is actually a UserName String.. so replacee the DLookUp with the following..

=DLookUp("[[COLOR=Blue]UserNameField[/COLOR]]","[User]","[[COLOR=Blue]UserName[/COLOR]]='" & [Forms]![frmLogin]![[COLOR=Blue]LoginTextBox[/COLOR]] & "'")

Please change all Blue Bits, also make sure you have the Login Form is made invisible NOT CLOSED

 

[surfrus]

how do i change too invisible and check it isnt closed?

 

[khodr]

Hi,
it is a very simple issue to show the logged user name in the current form,
I have user login form, when I click the button and the code checks the password and user name is meeting the condition then the login form will be hidden and the main form will show, then i have a unbound combo box I set the value for it
=[Forms]![User_frm_Login]![UserName]
and it works like charm,
I hope that could help you.

 

[pr2-eugin]

I have mentioned about how not to close the form in Post No. 8

 

[khodr]

well what you need to do is, on your command button on click event which loads the next form you need to add this line.
Me.Visible = False