Access Form with multipe tab controls

Question

This is not a deveoper question, it's a novice question from someone that has used Access as a front end for a SQL database for years with no probems. I've now created a stand alone access database that I've created for various staff to fill out different pages of a three page form. The form has control tabs for pages 1, 2 and 3. Each page has the social security number of an individua on it. Pages 2 and 3 are just memo fieds except for the SSnumber. I have created 4 records for individuals. When I try to print or do a print preview from the form, it shows just the first page for each individual. If I save it as a report, it does the same thing.

How can I get three pages to print for each individual, or just print three pages on one individual?

Answer 1

Personally, I would separate your reports from your user interface. That way your report can be exactly what you need rather than making a duel purpose form.

Answer 2

If you don't want to use the report wizards to build a custom report, then how about removing the tab control and building a long (vertical) form with all the fields in it in three sections, with a vertical scrollbar. Then the print should work.