Prev: dividing lines
Next: Check Control if Visible or hidden
From: patti on 4 Mar 2010 14:17
I am using a tabbed form.
Tab A is based on ProjectTable with PK=ProjID
Tab B is based on ProjectDescTable with PK= ProjDescID and links to
ProjectTable with a field for ProjID. Tab B's child field is ProjID and
mother field is from Tab A's PK field.
Tab C is based on ProjTasksTable with PK=ProjTaskID and links to
ProjDescTable with a field for ProDescjID.

I want tab C to link to Tab B. Mother field would be ProjDescForm's
ProjDescID and child field would be ProjTaskForm's ProjDescID. The wizard
only shows me fields from Tab A.

Is there a way to link Tab C to Tab B?

Thanks.
From: John W. Vinson on 4 Mar 2010 17:09
On Thu, 4 Mar 2010 11:17:01 -0800, patti <patti(a)discussions.microsoft.com>
wrote:

>I am using a tabbed form.
>Tab A is based on ProjectTable with PK=ProjID
>Tab B is based on ProjectDescTable with PK= ProjDescID and links to
>ProjectTable with a field for ProjID. Tab B's child field is ProjID and
>mother field is from Tab A's PK field.
>Tab C is based on ProjTasksTable with PK=ProjTaskID and links to
>ProjDescTable with a field for ProDescjID.
>
>I want tab C to link to Tab B. Mother field would be ProjDescForm's
>ProjDescID and child field would be ProjTaskForm's ProjDescID. The wizard
>only shows me fields from Tab A.
>
>Is there a way to link Tab C to Tab B?
>
>Thanks.

A Tab Control on a form is *NOTHING* but a way to save screen space. Controls
on a tab page are logically on the Form. You can't "link" tab pages as you can
subforms.

Is there a Subform Control on Tab B? If so, the controls are on that Form...
not on the tab page.
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: dividing lines
Next: Check Control if Visible or hidden