A few days ago I posted a question on dependant lists using combo boxes from
the FORMS toolbar. It appears as though I will have to use the combo box from
the control toolbox because as hard as I try I cant seem to get the FORMS
combo box to work. FSt1 did his/her best to help me and suggested it might be
worth using a select case. I have never heard of this before so I would be
grateful for some help using this function. What I have is a survey that
includes 2 drop down lists in combo boxes. The first list has approximately
10 categories and in the second list there are about 10-15 sub categories per
category. I want people to be able to choose a category from the first list
and then the second list will bring up the appropriate sub categories. I
would appreciate any assistance as this is driving me insane.