Record or Form editing control

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

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