469,344 Members | 6,216 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,344 developers. It's quick & easy.

Checkbox to Lock a Specific Record

Hello Everyone,

I am looking to create a checkbox in a form that when checked by the user locks that specific record so that it cannot be edited until another user unchecks the box. This is intended to prevent anyone from accidentally modifying a record, but still allowing them to do so if necessary.

The check box is labelled "RMA Closed", and when checked should lock the record.

Any help would be greatly appreciated as I have looked all over and cannot find code to this specific task.

Cheers,
Evan
Jun 1 '07 #1
1 1198
I forgot to mention I'm using Access 2003. Sorry, I'm new around here.
Jun 2 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

By using this site, you agree to our Privacy Policy and Terms of Use.