Populate UserName into a field

[imdl]

I found the module [http://www.mvps.org/access/api/api0008.htm] and I have the text box =fosusername() that shows the user's login name.

I need help on how to populate the user's log in name onto the field in the table whenever a new record is created.


imdl

 

[imdl]

Never mind, i found the answer. =)

 

[HiTechCoach]

would you be kind and share your solution so others may benefit

 

[imdl]

yeah, here's the code:

Private Sub Form_BeforeInsert(Cancel As Integer)
Me.txtName = fOSUserName()
End Sub

(txtName is the text box on the form)



imdl

 

[Khalid_Afridi]

yeah, here's the code:


Me.txtName = fOSUserName()

imdl

was that the problem????