Readonly fields in forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ramesh - 21 Feb 2007 03:46 GMT

HI,

Can i setup forms such in certain forms, only certain fields are editable?
eg i have one form in which i create the records. and another form in which
i am allowed to modify only one or two fields, the rest become like readonly
(in that form).

This is to protect the earlier entries when modifications to a field is
made.

Thanks for any help.
Ramesh

Reply to this Message

Rob Parker - 22 Feb 2007 12:41 GMT

You can set the Locked property of a control bound to a field in the
underlying recordset to Yes to prevent the value displayed in that control
from being changed.

So, if you want to set up an edit form for your data, set the Locked
property of all the textboxes to Yes, except for those you are allowing your
users to edit. If you set the Enabled property of the Locked textboxes to
No, they will not even be able to tab/click into that control.

HTH,

Rob

> HI,
>
[quoted text clipped - 8 lines]
> Thanks for any help.
> Ramesh

Reply to this Message

Ramesh - 26 Feb 2007 00:29 GMT

Thanks a lot Rob for that. Sorry my response is rather late.

ramesh

> You can set the Locked property of a control bound to a field in the
> underlying recordset to Yes to prevent the value displayed in that control
[quoted text clipped - 22 lines]
>> Thanks for any help.
>> Ramesh

Reply to this Message