Record or Form editing control

G

GL

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
 
M

[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
 
Top