locking a record

[oohmygod831]

is it possible once a record has been entered, to lock it so that it can not be changed by just anyone but that the administrator could change it using a password?

 

[boblarson]

Yes, you could put

If Not Me.NewRecord Then Me.AllowEdits = False

in the form's On Current Event

 

[oohmygod831]

can i set up a form to only be able to view the records and not be able to edit them, but if i click a form button i could then be allowed to edit. I want this to stop accidental editing of records.sorry for being a pain

 

[boblarson]

Just in the form's On Current event set:

With Me
   .AllowEdits = False
   .AllowDeletions = False
   .AllowAdditions = True
End With

That will lock it down to just additions.

If you want to unlock it use:

Me.AllowEdits = True
Me.AllowDeletions = True

whichever depending on your mode you want.

You won't have to worry about relocking because the locking will happen in the form's On Current event as you move to another record.

 

[oohmygod831]

cheers Bob that sounds just what i need, will let you know how i get on

 

[oohmygod831]

Thanks very much Bob, your tip worked exactly as i needed it too

 

[boblarson]

Thanks very much Bob, your tip worked exactly as i needed it too