can access disable a field based on the format of another field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I notice that this feature is avaliable in Infopath but im hoping someone may
know how to disable / enable a field based on a "yes/no" response in a
previous field.
For example the default response in the [US citizen] field is {yes}. When
users uncheck the box,leaving a {no} response, I would like the field [
international citizenship] to be enabled to enter the contry of citizenship.
 
Use the After Update event of the Check Box control:
Me.txtInternationalCitizen.Enabled = Not Me.chkUSCitizen

You will also need to put the same line of code in the Form's Current event
so it will set the value for existing records.
 
Thats a bit technical can you walk me through it? When I open the form in
design veiw:
- Select the field "international citizen"
- select "properties"
- select "events" tab
- go to after update then i have 3 options: expression builder, code builder
or macro builder. There is also the drop down box that ask about event
proceedure then takes me to another screen. What is this ?

Klatuu said:
Use the After Update event of the Check Box control:
Me.txtInternationalCitizen.Enabled = Not Me.chkUSCitizen

You will also need to put the same line of code in the Form's Current event
so it will set the value for existing records.

[email protected] said:
I notice that this feature is avaliable in Infopath but im hoping someone may
know how to disable / enable a field based on a "yes/no" response in a
previous field.
For example the default response in the [US citizen] field is {yes}. When
users uncheck the box,leaving a {no} response, I would like the field [
international citizenship] to be enabled to enter the contry of citizenship.
Click to expand...
Click to expand...
 
Actually, you want to use the Code builder option, but not in the text box
control. You want to use the combo box's after update to change the enabled
property of the text box.

[email protected] said:
Thats a bit technical can you walk me through it? When I open the form in
design veiw:
- Select the field "international citizen"
- select "properties"
- select "events" tab
- go to after update then i have 3 options: expression builder, code builder
or macro builder. There is also the drop down box that ask about event
proceedure then takes me to another screen. What is this ?

Klatuu said:
Use the After Update event of the Check Box control:
Me.txtInternationalCitizen.Enabled = Not Me.chkUSCitizen

You will also need to put the same line of code in the Form's Current event
so it will set the value for existing records.

[email protected] said:
I notice that this feature is avaliable in Infopath but im hoping someone may
know how to disable / enable a field based on a "yes/no" response in a
previous field.
For example the default response in the [US citizen] field is {yes}. When
users uncheck the box,leaving a {no} response, I would like the field [
international citizenship] to be enabled to enter the contry of citizenship.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top