I am designing a data base that has questions. I have a list of questions that are sperated into categories. The way I want it to work is one selects the category from a combo box then those questions pop up with a option menu box of Yes No N/A. I currenty have them set using

Code:
If Me.Combo15 = 1 Then
    Me.Label28.Visible = True
Else
    Me.Label28.Visible = False
End If
But I feel there has to be a easier way then setting EACH control (over a hundred) and stacking the questions on top of each other. I also need all this information to return into one table (which I know how to do, but it may be good information to know) Any suggestions out there??

J