MS Access database support - Help with Yes/No checkbox

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Help with Yes/No checkbox

Bobbie

2006-04-05, 8:28 pm

I am working on a form. I have 5 questions with yes/no check boxes. If
you choose No in question #2 I want 3,4, and 5 to automatically
populate No, they will not need to be answered. Please help. It is
driving me crazy.

Thanks,

Bobbie

pietlinden@hotmail.com

2006-04-05, 8:28 pm

Option Compare Database

Private Sub Q2_AfterUpdate()
If Me.Q2.Value = Unchecked Then
Me.Q3.Value = Unchecked
Me.Q4.Value = Unchecked
Me.Q5.Value = Unchecked
End If
End Sub

Crazy is left at the light and a couple of blocks down.

Bobbie

2006-04-06, 1:34 pm

It works. Thank you so much. The other directions helped out too,
although I usually don't have any trouble finding crazy. :)

pietlinden@hotmail.com

2006-04-06, 1:34 pm

the hard part isn't getting there... it's finding your way back.

Sponsored Links