Prev: Not saving records till "save" command button clicked
Next: Showing certain records in a form
From: kenrav on 30 Apr 2010 18:31
Is there a way to allow users the ability to make edits on one control on a
form, but not the rest?
From: Jeanette Cunningham on 30 Apr 2010 18:52
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


"kenrav" <kenrav(a)discussions.microsoft.com> wrote in message
news:D365C90B-826B-4C3C-B150-5BAA66FA5CC8(a)microsoft.com...
> Is there a way to allow users the ability to make edits on one control on
> a
> form, but not the rest?


 | 
Pages: 1
Prev: Not saving records till "save" command button clicked
Next: Showing certain records in a form