Locking Forms in Access 2000

Tags:
Access 2000
Access forms
Microsoft Acccess
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.
ASKED: March 5, 2009  2:24 PM
UPDATED: March 5, 2009  8:47 PM

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following