I have programmed in C++, Java, SQL & PL/SQL. However, I have only looked at VBA and thus need coding examples as well as direction for the following:

I am creating a form that has a dropdown from which the user selects how many persons to collect information regarding. The information needed will be the name of the person, whether or not that person is under the age of 18, and if under the age of 18 what the birth date is.

In order to make the form efficient to fill out for the user, I thought it might be best to have the prompts for name, under 18 and birth date be in a form box. My question is, within the form box, how can I make the number of text fields to include conditional upon the answer in the drop down? And in turn how can I make the inclusion of a text field for the birth date conditional upon whether or not the check box has been checked? Outside of a form box if I did these as individual form fields I know I could associate them with macros or nest the fields with if statements. But I don't see how to do this inside a form box.

Also, is there a better approach?

If I were in a language with which I am familiar, I might create an object that was the form box which would include a dynamic array or stack of objects that are the text field, check box & date text field. Would it be anything like this in VBA?