Deactivate field based on other field value

I

injanib

What I need to do is have some of the fields on the form deactivated (grayed
out) untill the value in the preceding field is a certain value or text. I
can't use conditional formating because I would need to use the values in the
object fields to be the conditions. In this case I need a the value of a
different field to be the condition.

What is the best way to do this.

Thanks in advance.
 
K

Ken

YOu could place code in the before or after update to enable and disable the
controls.

I would have one function that updates all the forms controls and have each
of the other controls call the one funtion. That way if a user goes back you
can update all the controls in one place.
 
M

Marshall Barton

injanib said:
What I need to do is have some of the fields on the form deactivated (grayed
out) untill the value in the preceding field is a certain value or text. I
can't use conditional formating because I would need to use the values in the
object fields to be the conditions. In this case I need a the value of a
different field to be the condition.

What is the best way to do this.
Click to expand...


Use Conditional Formatting with the Expression Is: option.

[other control] = certainvalue OR Not IsNumeric([other
control])
 
I

injanib

Thanks,

in the form I have a field called "RSA Type" which is a combo box with three
options (NCN, Temp, RSA). I want to following fields to be activated only if
the "Temp" is selected in the "RSA Type" field.

Can you tell me what the expression should be in the conditional formating.
 
M

Marshall Barton

injanib said:
in the form I have a field called "RSA Type" which is a combo box with three
options (NCN, Temp, RSA). I want to following fields to be activated only if
the "Temp" is selected in the "RSA Type" field.

Can you tell me what the expression should be in the conditional formating.
Click to expand...


For each of the text box controls that you want enabled:

Set the CF Default Format's enabled property to disabled.

Set the CF Condition 1 to:
[RSA Type] = "Temp"
and the enabled property to Enabled
 
Top