Answer No and have it fill in No's in other fields

[Guest]

What is the best code for the following:
I answer "No" in a field and then I would like it to automatically answer
"No" in 5 differrent fields in the same form and record?

 

[Graham Mandeno]

Hi Jerry

Use the AfterUpdate event of the first control (checkbox?)

Private Sub Field1_AfterUpdate()
If Field1 = 0 Then
Field2 = 0
Field3 = 0
Field4 = 0
... etc
End If
End Sub

 

[John W. Vinson]

What is the best code for the following:
I answer "No" in a field and then I would like it to automatically answer
"No" in 5 differrent fields in the same form and record?

well... the best result might be to properly normalize your database
so this doesn't need to happen... but...

Use VBA code in the control's AfterUpdate event. Is this a text field,
or a Yes/No field? Is the form control a Checkbox, Textbox, or Combo
Box?

John W. Vinson [MVP]