Record or Form editing control

[Guest]

Hi

I would like to control record editing in a multi user data base.
Record editing in that specific application is performed only through forms.
Do I have to set record locking, form locking, or both?
How can I do it programmatically?

Thanks

GL

 

[[MVP] S.Clark]

You can open the form as readonly. Place a command button that requires
being clicked to edit the record.

Docmd.OpenForm "Formname", ,,,acFormReadOnly

In the Onclick:
me.allowedits = True

In the after update for the form
me.allowedits = false