Preventing users from changing a record

mjn015

Registered User.
Local time
Today, 12:01
Joined
Apr 10, 2007
Messages
29
I'm not sure if this is a Table question or a Form question...

After a user enters data into all the fields on my form (ticket #, date, time, etc) and submits that form, I want to prevent them from going back to that record (or any record, for that matter) and make a change to it. Currently, they can do a "Find" on a specific ticket # while in the form and make any kind of change they wanted. ie: change the time they reported to a work site...

Is there an easy way to prevent this from happening?

Thanks!
 
In the form's properties, you can just go to Allow Edits and Allow Deletes and set them to NO.
 
Thanks Bob. That seems simple enough. I'm not sure how savvy these users are, but what's to prevent them from going to the Table and editing the record from the Table itself?
 
I think you'll probably want to implement Access user level security to do that. That way you can assign which user, or group, gets to open what.
 

Users who are viewing this thread

Back
Top Bottom