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?

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



Show quoteHide quote

Roger Bell wrote:
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...)

Roger Bell wrote:
This is also good:

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

Phil

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
'====================================================


Roger Bell wrote:
Show quoteHide quote

Need report to only select the "yes" based on month
Conditional formatting based on the Row Source in another control.
repeat information in report (Access 2007)
Report - how to print each page to new document.
Sorting based on selected value...Please help!
Remove Spaces
Linking to selected fields in an external table
Time Conversion
relationships
Auto populate month & year