Thanks in advance for your input.



I have all of my control fields in one Main Table.
All of my subforms are in a Primary-key/Foreign-key relationship with the main table.
There are too many control fields and subforms to fit on one Form grid.
Therefore, I need to split things out over multiple pages.
I’m thinking of trying to use tabs as a simple solution, but need some clarification on how to use them.

I open up a blank form in design view and add a Tab control. I can basically size the tab control to fit the full size of the form (in my case to fit within an 8 x 11.5 inch printable page).

Can I place ALL of my control fields and subforms directly onto the various tab pages (maximize the size to 8 x 11.5) or do need to leave space on the grid because some of the controls have to go onto the grid itself (such as the Autonumber Record ID field)?

Becasue everything is linked back to one Main Table, the data that will be typed into on each tab by the users will automatically be associated with one record (based on the Autonumber Record ID)?

Do I need to repeat the Autonumber Record ID field on each tab or need to have any written programming behind any Event Procedures to tie everthing together?