Record a user name in and acces form

[taylo40]

Hello,

I wonder whether anybody can help me ?

I have created a form in access that will be used by several users as an input sheet to record data from potential customers.

I have created a field called "Input By" and would like the user to enter their name. I have made the field mandatory but that will not stop rubbish data being entered in the field.

Is it possible for the access form to populate the field automatically with the users network user id ?

Cheers


Jamie

 

[xlbo]

you may use Environ("username") to automatically get the userID

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[randy700]

And Disable the field to prevent the user from changing it.


Randy