Best way to deal with multiple questionnaire types
Posted on 2014-12-19
I'm just looking for advice. I am creating a database for the purpose of an interview process. Questions and answers.
But depending on the individual filling out the questionnaire different sub-forms need to be presented. There will be one main form for general questions and answers. But then depending on the type of application being filled out, different sub-forms need to be opened on the main form.
Is there a way via VBA code to do this or do I need several main forms with their respective sub-forms designed into them?
If different sub-forms can be presented to the user what type of code needs to be included in the main form to make them open?