I am making a form, with the "Autonumber" and "User Name" as locked controls which cannot be changed when adding information to the form. The 'Autonumber' on the form is done when a command button on the frmMainForm is pressed saying 'New Task'. The users are also logging into the database with a user name and password.

What I am trying to do is:

1. Make the "autonumber" field locked so that it will not change if it is opened by someone else for editing.

2. Make the "user name" field populated by the person who ORIGINALLY started the task and will NOT be over-written by someone who opens it to be edited.

Is this possible?

Graf,

Use Access's own 'autonumber, but if you need to 'see' it just have it on the form as not editable.
Personally, I don't ever use the autonumbers for any client related info. What they can't see, then can't mess with. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)

As to the User name control, have it that if null let them enter their name, but once its no longer null,
turn off edit for the control.

Good luck, (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)

Aqua