Tab Control

[Roger Bell]

I have a single form with many fields in the Form. I have added a Tab
control to the form with 2 pages, to split the fields onto two pages The
problem is that when I click on either page the fields are repeated. If I
try to cut and paste from 1 page to the other, I lose the fields on both
pages.

Can anyone help please?

 

[Wayne-I-M]

Hi

Create 3 forms
MainForm
FormTab1
FormTab2

Open MainForm in design view
Add 2 tab controls
On the first tab add FormTab1
On the second tab add FormTab2

You will need some linking field to join the forms (prob an ID on the
MainForm - make sure this is on the FormTab2 and then add the ID (of the
related record on the 1st tab) to the FormTab2 - this will likn the 2 tabs

 

[Philip Herlihy]

I have a single form with many fields in the Form. I have added a Tab
control to the form with 2 pages, to split the fields onto two pages The
problem is that when I click on either page the fields are repeated. If I
try to cut and paste from 1 page to the other, I lose the fields on both
pages.

Can anyone help please?

I wonder if your fields are located not on the tab, but above it,
directly on the form? If you select the tab control and bring it to the
front, the other fields would disappear if I'm right.

It's a while since I've done this, but I seem to remember you have to
cut the field, select the tab, and then paste. Or something like that!

(Googled). Yup, that's it. See:

http://office.microsoft.com/en-us/access/HA012300491033.aspx

"If you drop a dragged field while a tab page is not highlighted, the
control will be created on the form, but not on a page of the tab
control. If this happens accidentally at this stage, delete the
newly-created control from the form and try again"

HTH

Phil, London
(I'm good at the easy ones...)

 

[Philip Herlihy]

I have a single form with many fields in the Form. I have added a Tab
control to the form with 2 pages, to split the fields onto two pages The
problem is that when I click on either page the fields are repeated. If I
try to cut and paste from 1 page to the other, I lose the fields on both
pages.

Can anyone help please?

This is also good:

http://www.jegsworks.com/Lessons/databases/formsreports/step-tabcontrol.htm

Phil

 

[John Spencer]

The problem is that you are probably not pasting the fields onto the tab
pages but onto the form.

Cut the controls you want to see on one of the tab pages. Now click on
the tab page you want them on and then click in the center of the tab
page. You should see 6 small squares appear around the edges of the tab
page. Now paste. If that works, repeat for the other controls.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================