Forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jeff@jeffscomputerservices.com - 01 Feb 2007 10:28 GMT

Hello everyone,
My mind has gone and for the life of me I can not remember this simple
task. Would someone help me remember. Here it is:
I have a form and the text boxes are locke on this form. I would like
a command (Event Procedure) to unlock the text boxes (Form).

Thanks in advance,
Sincerely,
Jeff

Reply to this Message

Allen Browne - 01 Feb 2007 11:39 GMT

See:
Locking bound controls on a form and subforms
at:
http://allenbrowne.com/ser-56.html

The code is recursive so it locks/unlocks the controls in the subforms also
if you need to process subforms.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hello everyone,
> My mind has gone and for the life of me I can not remember this simple
[quoted text clipped - 5 lines]
> Sincerely,
> Jeff

Reply to this Message

rkc <"rkc"@rkcny - 26 Feb 2007 01:42 GMT

> Hello everyone,
> My mind has gone and for the life of me I can not remember this simple
> task. Would someone help me remember. Here it is:
> I have a form and the text boxes are locke on this form. I would like
> a command (Event Procedure) to unlock the text boxes (Form).

Depends on what you mean by the text boxes are locked.
I could be as simple as setting the AllowEdits property
of the form to true. Me.AllowEdits = True

It could be as involved as looping through the controls and
setting each control's locked property as suggested in another reply.

It could be that the form's record source is simply not updatable.

Reply to this Message