Disable a field

[McDonald]

On my form I wan't to disable a field unless a certain option is selected.
For example, If female is selected from an option group, I want the maiden
name field to be active. Maybe in even more depth. for example, if female
is selected from the option group and married, divorced, or widowed is
selected from another option, but leave in active if single or never married
is selected.

 

[Joe Voll]

On my form I wan't to disable a field unless a certain option is selected.
For example, If female is selected from an option group, I want the maiden
name field to be active. [...]

write an AfterUpdate event that enables or disables the Maidenname field
according to your chosen option.

Joe Voll.

 

[McDonald]

What paramaters do I enter in the after update? I know where to put it,
just not what to put in.

On my form I wan't to disable a field unless a certain option is selected.
For example, If female is selected from an option group, I want the maiden
name field to be active. [...]

write an AfterUpdate event that enables or disables the Maidenname field
according to your chosen option.

Joe Voll.

 

[Gary Miller]

Something like this would a way to go. I would think that
you would need to make sure that the single/married is
checked before the Sex field where you would use the
AfterUpdate. Obviously, you will need to substitute your
control names and maybe outputs to fit your controls and
data.

If Me!MaritalStatus = "Married" or Me!MaritalStatus =
"Divorced" then
If Me!Sex = "Female" Then
Me!MaidenName.Enabled = True
Else
Me!MaidenName.Enabled = False
End If
End If

Gary Miller
Sisters, OR

What paramaters do I enter in the after update? I know where to put it,
just not what to put in.
option is
selected. group, I want the
maiden

name field to be active. [...]

write an AfterUpdate event that enables or disables the Maidenname field
according to your chosen option.

Joe Voll.