MS Access Form w Tabs

[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)

 

[John Spencer]

If the data is all in one table, then you don't want to use subforms on the
tabs. You would probably end up with record-locking conflicts.

You do want to use a tab control to group the data into screens

Your current problem is that your have no controls on tab 1, they are on the
main form. SELECT all the controls that you see when you are viewing tab 1.

Cut them,
click on the tab 1 header
You should see 6 handles appear in the tab control (6 small squares)
Paste the controls you have cut. They should now be on page 1 of the tab
control
Flip to page 2 of the tab and check.

The trick is to make sure atab page has the focus when you add controls. If
you don't, then the controls get added to the form instead of to the tab
control on the form.