AllowEdits

  • Thread starter Thread starter kenrav
  • Start date Start date
K

kenrav

Is there a way to allow users the ability to make edits on one control on a
form, but not the rest?
 
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
 
Back
Top