How to Capture your Database User's Name

[CoolFactor]

I was wondering if anybody knows how to capture
the Database User's Name in a text box on a Form.
I have my table with my Users along with their username and
password.

I have a logon form that I created with a combo box and a
text box that capture my Users name and password.

 

[PHV]

The database user's name is CurrentUser

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[CoolFactor]

I don't think you understood what I was saying. What I mean is, I am trying to capture username in from the Logon
Form in another Form within a textbox.

 

[PHV]

Like this ?
Forms![another Form]![textbox] = Forms![Logon Form]![username control]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[CoolFactor]

I inputted this with a few changes into the control source of the text box and it doesn't seem to work.

Forms![another Form]![textbox] = Forms![Logon Form]![username control]

Here is what I inputted:
Forms![frm_Main]![Text145] = Forms![frm_Logon]![Combo0]

 

[PHV]

I gave you VBA code.
As ControlSource you may try this:
= Forms![frm_Logon]![Combo0]

Note: the logon form must be open.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[CoolFactor]

That doesn't seem to be working either.

 

[TheAceMan1]

How are ya CoolFactor . . .

Hmmmm . . . post what you've tried! . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[CoolFactor]

= Forms![frm_Logon]![Combo0]

 

[CoolFactor]

This is what I tried:

= Forms![frm_Logon]![Combo0]