Creating cascading sub forms off of Main form

[Viper210]

In a nutshell, I have this humongous questionnaire that is nine pages on paper and will total about seven or eight sub forms in order to complete the questionnaire in Access.

I would like to have command buttons on main form / sub form to take me to the next sub form (or previous one) and closing the previous sub form.

Finally having an end/complete button to save all the information to the main form record.

Since joining this forum, I have run across some pretty sharp cookies that were able to help me (sometimes within the same day) with solutions to previous issues, and hope that someone can give me at least the framework to figure out how to start.

I have only been using Access for a couple of months, so If you reply, please respond with “Access for Dummies” terminology. I am still getting myself up to speed.

 

[delikedi]

If you are referring to subforms in the sense that one refers to the pages of a notebook, then what you need is probably a tab control with several pages on a single form.

If your questionnaire consists of, say, 90 questions and each of them are going to be answered by everyone, than you have to start by making a table with 90 fields. You then build a form on this table, and place a tab control on it with 9 pages. Then you can place the controls on those pages, 10 for each page.

I your questionnaire consists of one or more sub sections that may be omitted with respect to the person taking the questionnaire, then things will get a bit more complex.

 

[Viper210]

As I stated in the initial post I am very new to Access. Could you please provide more detail on how to:

1. Create a "Tab control"

2. Add pages to the tab control