Making Fields Editable

Xavi

We have a form(Say UserForm1) the Controls has to be made Editable or not editable depending on a value Selected. The value is to be selected from another table(table1) which has a primary Key and the fields from Userform1 as its field. It'll be having value true/False. If the value is true, after the selection of the Code, the fields in userform1 has to be made editable and Vice versa.



Example:
Userform1-Controls-C1,C2,C3



Code--- C1--- C2--- C3 (Fields)

A--- true--- False--- True
B--- False--- True--- True (Values)
C--- False--- False--- True
......
......
......

Help me... ](*,)

Xavi

RobertMo

Check the function EDITABLE:

EDITABLE
Use this function to return the current setting of the Editable property, and to change the setting of the property.

[IsEditable] := EDITABLE([SetEditable])

IsEditable
Data type: boolean
The current value of the Editable property.

SetEditable
Data type: boolean
The new setting of the Editable property.

You could use it then like:

rMySettings.GET("My Code");
CurrForm."Your Filed C1".EDITABLE(rMySettings."Is C1 Editable");
CurrForm."Your Filed C2".EDITABLE(rMySettings."Is C2 Editable");
CurrForm."Your Filed C3".EDITABLE(rMySettings."Is C3 Editable");

Xavi

That's exactly what i needed....It's working... Thanks Robert.