Hello,
what I intend to do is data quality cotrol whatever is selected from combobox( Yes, No, NA), if NA selected then the next several fields will be skipped (disabled). i use the follwoing code, it doesn't work, it works the same code in other field. i don't know why. i would appreciate if any one can help me find out. thanks a lot
Private Sub change_smoking_AfterUpdate()
If (Me![change smoking].Value <> "1") Or (Me![change smoking].Value <> "0") Then
Me![Ceased smoking].Enabled = no
Me![Ceased smoking].Value = " "
Me![ReducedSmoking].Enabled = no
Me![ReducedSmoking].Value = ""
Me![IncreasedSmoking].Enabled = no
Me![IncreasedSmoking].Value = ""
Else
Me![Ceased smoking].Enabled = (Me![change smoking].Value = "1") Or (Me![change smoking].Value = "0")
Me![Ceased smoking].Value = " "
Me![ReducedSmoking].Enabled = (Me![change smoking].Value = "1") Or (Me![change smoking].Value = "0")
Me![ReducedSmoking].Value = ""
Me![IncreasedSmoking].Enabled = (Me![change smoking].Value = "0") Or (Me![change smoking].Value = "1")
Me![IncreasedSmoking].Value = ""
End If
End Sub