locking of a record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a form view, what is the best approach to locking a record. I'm
anticipating having a toggle box that can be selected.

I'm new to access so any detail on how to approach this is appreciated.
 
Zanstemic said:
In a form view, what is the best approach to locking a record. I'm
anticipating having a toggle box that can be selected.

I'm new to access so any detail on how to approach this is appreciated.
Click to expand...


Depends on what else is going on in your form. One way is
to just set the form's AllowEdits property to True or False.
 
If you want the toggle box to enable and disable editing,
then No, you can not. When AllowEdits is False, you will
not be able to change the toggle box either.

You can use a command button to flip the state of AllowEdits
by using a Click event with:
Me.AllowEdits = Not Me.AllowEdits

If that's not sufficient, please provide more details.
 
Back
Top