How do i lock and unlock data edition i my form with a bottomcontrol.

[Hasse]

I want to prevent accidental modifications of items of data in my form.
It is easy to preset the mode for read only in the properties window but i want to change the mode
betwen "read only" and "alow edit" with a function-bottom.
Can it be done?

[June7]

Yes. Code can set the form properties: AllowEdits, AllowDeletions, AllowAdditions.

[ItsMe]

Here is a basic example of using controls on a main form to manage some of the properties on a subform.
https://www.accessforums.net/sample-...tml#post190509

[Missinglinq]

Code can set the form properties: AllowEdits, AllowDeletions, AllowAdditions.

Like this, where the Command Button is named cmdAllowEdits:

Private Sub Form_Current()
 Me.AllowEdits = False
End Sub

Private Sub cmdAllowEdits_Click()
 Me.AllowEdits = True
End Sub

Linq ;0)>