Subforms with Tabs in Access 2003

[jaypoppin]

I believe this is a simple question; it seems I'm just simpler.



I've created a form that basically includes all of the fields of the central table of my small database.

Each key-numbered entry in the main table belongs to one client.

I created two separate tables for two different types of employees that can be assigned to a client (many can be assigned to an individual client).

I created two more tables to keep track of these assignments (each assignment being auto-numbered).

I want, in my form, a subform to drop down that has two tabs, one for each type of employee-assignment.

I can create a subform for one, or the other. Creating one subform that includes both at the same time seems to send the whole thing haywire (no doubt because of some design flaw).

I cannot figure out how to just tab two different subforms.

Please help, and much thanks in advance.

[alansidman]

Is this helpful?

http://www.datapigtechnologies.com/f...abcontrol.html

Alan

[jaypoppin]

Sort of. So my form is in datasheet view, which is how I prefer it to be.

In design view, below the main elements of the form, I added a tab control. And in each of the tabs added a subform.

However, when I go to view the form, and I drop down the subforms, it only shows the first tab. I can change the order of the tabs in design view, and that will change which tab drops down as a subform.

But how do I get it so that what drops down shows all three subform tabs, with the option to move between them?

Thanks.

[June7]

I am doubtful that is possible in datasheet view.