Capture User Name Instead Of User ID

[yrstruly]

My user name/i.d consist of this table:

UserID Username
1 Armand
2 Adam Septe.

It displays the logon user name on my logon form, using this

=[Forms]![frmLogon]![User]

SELECT tblUsers.UserID, tblUsers.Username FROM tblUsers;

I take this data and display it into a new form/table, in a column called Captured by using this code.

Private Sub Form_BeforeInsert(Cancel As Integer)
    Me!CapturedBy = Forms!frmLogon!User
End Sub

It captures the User ID and not the User Name? I want the User Nme to be Captured.

[CJ_London]

perhaps

Me!CapturedBy = Forms!frmLogon!Username



All depends on what your form controls are named

[ArviLaanemets]

It looks like on form frmLogon you have a combobox named User for selecting the user to log on. With SELECT expression you posted as RowSource. The combo displays (and allows to select) the user name, but the value of combo will be UserID.

In case you want the logon info inserted into another form, it must be inserted to control linked to UserID in source table in this form. You can have this control as combo with RowSource similar to one in frmLogon - then the combo in this form also displays the user name depending the UserID in tblUsers.

In case you want to insert the logon info into table directly, then this is a very bad idea. The best policy with access (or any relatonal database) is to hide all tables from users and allow any data entry through forms, procedures, or queries only.

[June7]

If you want UserName, why bother with even having a UserID field? Which field is designated as primary key in tblUsers?

What data type is CapturedBy?

Either remove UserID from combobox RowSource or reference UserName column by its index.

Me!CapturedBy = Forms!frmLogon.User.Column(1)