locking and unlocking a form

[MJD1]

hi all, I've got a form for which I want users to open, view records with the ability to add, edit or delete records only when an "edit button" is clicked. Essentially, I need to learn how to lock and unlock all the fields in a form.

any help is appreciated!

martin

 

[Ed2020]

You can change the AllowEdits, AllowAdditions and AllowDeletions if the form is bound.

Alternatively you can use something like this:

   On Error Resume Next

   Dim MyCtrl as Access.Control

   For Each MyCtrl in Me.Controls
      MyCtrl.Enabled=False
      MyCtrl.Locked=True
   Next MyCtrl

Ed Metcalfe.

Please do not feed the trolls.....

 

[MJD1]

Thanks for the help, the below put me in the right direction.