AllowEdits

[kenrav]

Is there a way to allow users the ability to make edits on one control on a
form, but not the rest?

 

[Jeanette Cunningham]

You can lock the controls which are not to be edited.
To lock a control, on its property dialog, on the data tab, set locked to
Yes.

You can also lock a control with code:

Me.[ControlName].Locked = True

Note the square brackets are required if the control name has spaces or
special characters.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia