MS Access Forms with Tabs Help

[ghadley_00]

I have an MS Access Database with multiple forms that all update fields
in a single table because I can't fit all the required fields onto a
single screen. I have looked into converting these multiple forms into
a single form with subforms as tabs but to date my attempts to do this
have failed. Can any one give a pointer to an example / instructions on
how to create a tabbed form?

The form that I have created contains each of my current forms a
different tabs, however when I choose tab 2, it shows the contents of
both tab 1 and tab2 at the same time (making an incomprehensible
eyesore).

Any help that could be provided would be greatly appreciated.

Best wishes,

George Hadley
(e-mail address removed)

 

[Sandra Daigle]

Hi George,

First things first, if you have that many fields in one table you probably
have a de-normalized design. Do a little research on normalization to get
more information on normalizing your data.

Regarding the controls that all appear to show on tab2 - the controls on
tab1 are probably not actually on the tab page but are on the main form and
they are just showing through the tab page. To be sure you probably need to
Cut controls and then Paste them on to the tab page. Make sure that after
you Cut the control, you click the tab for the correct page, then Paste. If
you have any event procedures for these controls you will have to relink
your event procedures by selecting the "[Event Procedure]" option for the
relevant events.