Locking record

[RussG]

Had a good look at previous posts but couldn't find exactly what I am after.
Having entered a record I don't want users to go back and edit/amend the input. I can see how to lock and unlock records but controlling this wilt say a checkbox also means any user can 'uncheck' and edit. Is there a method to restrict who can unlock ('uncheck') and edit a record, other than using Access Security permissions.
Thanks
RussG

 

[mhartman]

Hello:

What you want to do is cycle through the controls collection on your form and at each control set its locked property to "True" (Locked). You want to repeat this procedure when you want to unlock the controls.

Regards
Mark

 

[unclejoe]

Hi,

The checkbox is always hidden from the user. Set the checkbox property to Visible = False.

Have the Form’s AfterInsert Event (not the checkbox or other controls event) to change the Checkbox value to True like,

Me.CheckBoxName = True

The Current Event will take care of the Edit Property of the current record.

As for Authorized users to edit records, you may have to create a subroutine or function to unhide the checkbox or simply change the form’s edit property or create another form for editing.

Had a good look at previous posts but couldn't find exactly what I am after.
Having entered a record I don't want users to go back and edit/amend the input. I can see how to lock and unlock records but controlling this wilt say a checkbox also means any user can 'uncheck' and edit. Is there a method to restrict who can unlock ('uncheck') and edit a record, other than using Access Security permissions.
Thanks
RussG

 

[RussG]

Thanks for the replies. This gives me a few ideas on how I can implement this.
Cheers
RussG