Need to protect data input

[Lynniebird]

As employees update information in the database, I need to make sure the
information cannot be changed. How can I do this?

 

[Keith Wilby]

As employees update information in the database, I need to make sure the
information cannot be changed. How can I do this?

So you want your users to be able to update data but not change it? That
makes no sense, would you care to elaborate?

Keith.
www.keithwilby.co.uk

 

[Lynniebird]

Once the data is entered, it needs to be secured so that no changes can be
made. A new entry will have to be made from that point on--no changes can be
made to the data after it is entered. Project tracking is very critical in
this industry and we must protect from accidental deletes.

 

[Keith Wilby]

Once the data is entered, it needs to be secured so that no changes can be
made. A new entry will have to be made from that point on--no changes can
be
made to the data after it is entered. Project tracking is very critical
in
this industry and we must protect from accidental deletes.

Forms have an Allow Deletes property. Set it to No.

To "lock" the contents of a record I would suggest setting the content of a
Boolean field in the form's Before Update event. Then in your form's
Current event you would set the form's Allow Edits property based on the
Boolean field value.

Naturally, you would not want to allow access to the Boolean field to your
users.

HTH - Keith.
www.keithwilby.co.uk