How do I link two forms to one table?

[wee.gray]

Hi folks I hope you can help me- I have never used access (2003) before and am under pressure to help a group of people input data from thousands of questionnaires using access forms (desired over a huge excel spreadsheet to minimise typing errors). The shorter questionnaire booklets have been no problem as all the questions fit on one form and link to one table, I am finding with longer booklets that there isn’t enough room on the form for all the questions in the table , I have tried subforms but the users aren’t happy with scrolling through little sub windows, they want a button to take them to the next ‘page’; I have made an additional form with the remaining questions on but I can’t get it to link to the first part of the form via a command button.
My VBA skills are coming on but I’m still learning this too.
The basic design is this:

Table 1: input columns for questions 1-9 (within each question people were able to tick multiple choices and so I have given a yes/no choice for every possible choice making 60 columns)
Form1part1 primary key and questions 1-7 with tickbox option groups
Form1part2 questions 8-9 with tickbox option groups

Please don’t be offended if this is a simple one, I’ve been struggling with it for hours now

All the very best,

Gray
ps let me know if you need an attachment- I'll try and work out how to do that!

 

[Mr. B]

Use a tab control on your one form. Organize your controls on the tabs as required. You should be able to have all the room you want and all controls (fields) will still be on the same form.

 

[Alansidman]

Why not put tabs on your form--in this manner, it appears as one form with several pages.

Look here for an idea on how it works.

http://www.datapigtechnologies.com/flashfiles/tabcontrol.html

 

[wee.gray]

Thats Great thanks so much, I'll google adding tabs to an existing form as I keep getting errors like; cant add any more controls to form when I cut and paste.... but this will solve my problem- wish I'd asked you sooner!
Thanks again
Gray

 

[Mr. B]

If you are getting this message, you may have exceeded the total number of controls that you can add to any one form over its lifetime. If this is the case, just create a new blank form and either start from scratch by adding the Tab control first and then the other controls you need, or only copy the controls you need from your previous form and place them on the new form in the tab control.

One word of advise; when adding controls to a tab control, always make sure you are actually placing the control on the tab control and not just placing the control on the form. Controls that are placed directly on the form will be visible no matter which tab is selected. Controls that are placed on one tab of a multi-tab control will only be seen with that tab is selected.