Locked Records

G

Galsaba

Is it possible to make some of the records locked, so I cannot edit them, and
some that will be editable?
I know how to open the form in a view mode only, but I don't know if it is
possible to control each record, that some i can edit, snd some I can view
only.

Thanks,

Joe
 
K

Kevin S.

Add a boolean (true false) field to the table called NoEdit. Then for the on
current event of the form....

me.allowedits = not noedit

I think that should work. I don't have Access available right now

-Kevin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 Level Record Protection 0
How to clear areas of a locked Doc after each use-- 0
need help ASAP word 2016 recipient cant edit 0
Only Files received through email are being blocked 0
Make "File in use" message appear when 2 people open the a shared document in the same time 3
Split form 0
Access Lock File .LACCDB / Now shows as a notepad file 0
Protecting Word 2019 document 0

Top