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?

Bryan,
One way to do this: You could make the form unbound. Then, give the user a button to "Save" their entries. When the record saves, your autonumber field will increment and populate. You could also (at log in) take the user id or name and store it in a global variable. When you create the record for the first time, take the value of the variable and populate the User field.

HTH,

Loralee

Loralee,

I am trying to make it so that when a user clicks "add new task" from the main switchboard, the "autonumber" for TaskID is put there automatically, shown to the user but they cannot change it. It stays constant.

The other thing that I am doing, because multiple people are going to be accessing the db to see, edit and perform further actions on the same tasks, is to make the "User Name" text box much like the "Task ID" text box. The first and ONLY the first time that the person who originally created the task, their db user name populates that field and it cannot be changed no matter how many times the task is opened, edited, or otherwise. It is a way to track who did what, should the task be 'lost' or misplaced.

Hiya,

First and foremost, if the field is autonumber, then it can't be changed by a user. If you want to display it, it is only a matter of formatting. Open the properties dialog box on the autonumber text box, select the data tab, and select Enabled = No, Locked = Yes.

You can also do the same thing for the User Name text box.

The users may be able to open the tables, however, so you will have to set their properties to Hidden, but that is only for most users. Other people can figure that out.

Another method is to create four fields in your tables, call them DateCreated, datetime, Default Value Now()
WhoCreated,
DateModified,
WhoModified.

Then on the Before Insert event of the form, do this:

Me.WhoCreated = 'where ever you are storing the username

Then on the Before Update event, do this:

Me.DateModified = Now()
Me.WhoModified = 'where ever you are storing the username

Then put these text boxes on the forms, but set Visible to No.

Did that help any?



mmcdonal