Locking Forms in Access 2000

Tags:
Microsoft Access
Microsoft Access 2000
Microsoft Access forms
I am using access 2000. I have created a form based on a table filled with tons of information. This is a multi user form. At the end of all of the records a blank form is presented so that the multi users can enter their appropriate information. However, some of the user are going through and making changes to fields on some already completed forms. I can't just lock the records on the forms because then they won't be able to go in and enter their required information on the blank form. WHAT CAN I DO TO FIX THIS IT'S KILLING ME. PLEASE HELP.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

I would set the Allow Edits and Allow Deletions properties for the form to No and the Allow Additions to Yes. This will allow the user to add new records but not be able to edit existing records.

Dustin

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: