TAB CONTROL RECORDSOURCE FAILURES

[Steve Cheese]

ACC2000: I have a form with a tab control, the tab holds
three separate "Many" datasheets that link to the the
form's "One" data.

No matter how carefully I place the 2nd & 3rd subform
datasheets on pages 2 & 3, the tab control keeps losing the
recordsources, and displaying (repeating) the datasheet
from page 1.

I have tried compacting, importing into a new MDB, and
other similar procedures. No luck so far. Any suggestions?

I have been able to get tables or queries to display and
remain stable on pages 2 & 3. But subforms keep failing.

 

[John Vinson]

No matter how carefully I place the 2nd & 3rd subform
datasheets on pages 2 & 3, the tab control keeps losing the
recordsources, and displaying (repeating) the datasheet
from page 1.

It's tricky to put any sort of control onto a tab page (Subforms or
anything else): if you just drag the control onto the page, it is not
"on" the page, it's still on the main Form *IN FRONT* of the page.
Selecting different pages leaves the subform (or textbox or whatever)
visible.

You must select the subform; type Ctrl-X to "cut" it; select the tab
of the tab page (the page itself will darken indicating that it's been
selected); and then type Ctrl-V to paste it onto the page.

 

[Steve Cheese]

I eventually decided that the tab control in question was
corrupted. When i deleted it, and started over, all the
problems that I was experiencing . . . disappeared.