Hi all I'm back again with some more questions.

I have a form on a split database with multiple users (taking phone messages). I already have the form set up so the user can only enter new data in it so that there is no mishaps of messages being typed over. However, I want other users (returning calls) to be able to go view the information on the table. I want the users returning calls to only be able to edit certain fields in the table. Is there any way I can lock only the fields that I dont want them to be able to edit?

Also, another question...

My ID is my primary key which orders numerically with each record (1,2,3...ect.) I deleted the first couple test records but the ID continues to numer from where the last deleted record left off (4,5,6..ect.). How can I get it to start back at one?

1. When the form is in Design view, open the Properties window.
2. Select the control you want to make read-only.
3. Select the "Data" tab in the properties window.
4. Change the value of the Locked property to Yes.
Normally, you should never do that. Values generated in an Autonumber column should be reserved for the internal mechanism of a database and never be accessible to the user for whom they are meaningless.

Here's a solution, however never use it in a database in production.
1. Delete all rows from the table you want to reset.
2. Create a new query and switch to SQL view.
4. Type this in the query (replace "TableName" by the name of your table and "TableColumn" by the name of the Identity column):
5. Execute the query.

Thanks, for the help everything worked out great.
Thank you.

You're welcome!