user name on main form

[foxtet]

Hello friends;

Here attached is a zipped copy of login sample database. There is a loggin form at start up. I want logged user name to be displayed on the main form and reports given in the database, I tried with DLookup function but I get #name error.

Can you help me to get a quick solution for this issue
fox

 

[Taruz]

Hi..

Private Sub Form_Open(Cancel As Integer)
Text17 = Forms.frm_Logon.cboEmployee 'add this to the.


Dim strFrm As String
strFrm = "frm_Logon"
.......
...................
.........................

End Sub

Also; if you define a variable global can use it anywhere ..

 

[raghuprabhu]

This small database might be of help to you.

Cheers
Raghu Prabhu