Thread: Allow edit button

Hello,

i know that there are a lot of info and posts about this issue, but i am not able to implement a button that will allow or not to edit the whole database.

I want to put such a control box in the main form, and i have seen that the code should be something like:

Me.AllowEdits = False

Me.AllowEdits = True

but could you specify where i should put those code, and how i could link it to the box??

Thanks in advance!

You can lock datasets that are attached/edited through forms, but I'm not aware of locking individual tables without open the db in Read Only mode. Me.AllowEdits would affect the entire form your dataset (recordsource) is attached to. It would prohibit edits on all fields. If you want to allow some fields to be edited and some locked, you'll need to lock an individual control on the form (textbox, combobox etc):

Me.myTextbox.locked = true
or
Me.myTextbox.enabled = false

Locked will simple lock the control from edits, while enabled will grey out the box (prohibiting edits as well).