Logon query

[techkenny1]

Hi all,

I have a query about a user that when he has logged on to his computer,being able to use his logon on access forms.

On our invoice system I have a text box in which the user who is generating invoices put in his initials.
However so oftem this is forgotten, so no audit trail.
The database also has a logon.

Is it possible to be able to use either the windows logon or the database logon so that the users name is automatically put into the users text box field when he generates an invoice.

Many thanks

 

[DimGeekAsString]

Try me.[txtMyUserField] = chr(34) & application.CurrentUser & chr(34)

 

[techkenny1]

Hi DimGeekAsString,
Many thanks for your reply.
Could yo utell me how to implement this code. Still a novice..Ive tried a few things but do't know where to go from here.

Many thanks