TAB Forms using individual Subforms

[Neal0o via AccessMonster.com]

I have searched and not sure if I am finding what I am looking for. I have
a form with two
tab controls using a different subform on each tab. I am try'n to display
individual employee
information from two different forms linked via relationship "one to many"
EMPLOYEEID

The employee information is broken down by Employee Information tab and
Inspections Tab.
would like the inspections tab to display the information based off which
employee is displayed
on the employee information tab.

One is this possible? I see the Link Master Fields and Link Child Fields. I
want to link more forms via
tab controls as well. Just don't want to fonfuse myself or anyone else at
this time. I can not use the ...
to link the fields because they are all unbound forms. I appreciate the help!
!

Hopefully this can work. Thank you..

Neal0o

 

[tina]

I am try'n to display

individual employee
information from two different forms linked via relationship "one to many"
EMPLOYEEID

I can not use the ...
to link the fields because they are all unbound forms.

i'm not following this. if the forms are unbound, then how are you
*displaying* employee and inspection data in them?

if one subform is bound to a tblEmployees, and the other subform is bound to
a tblEmployeeInspections, then you can put an unbound textbox control on the
main form, i'll call it txtID. set the control's ControlSource property to

=[SubformControlName].[Form]![EmployeeID]

(note: make sure you use the name of the *subform control* within the main
form, not the name of the subform form object in the database window -
sometimes the two names are different.)

click on the other subform control to select it. in the Properties box, set
the LinkChildFields property to the name of the EmployeeID foreign key field
from tblEmployeeInspections. set the LinkMasterFields property to [txtID].

btw, the tab control and the tab pages are irrelevant; they don't affect the
linking of the two subforms at all.

hth

 

[Neal0o via AccessMonster.com]

Tina,

Thank you... even though i didn't explain myself completely right you still
helped me solve my
problem... A big Thank you..

Neal0o

I am try'n to display
individual employee
information from two different forms linked via relationship "one to many"
EMPLOYEEID

I can not use the ...
to link the fields because they are all unbound forms.

i'm not following this. if the forms are unbound, then how are you
*displaying* employee and inspection data in them?

if one subform is bound to a tblEmployees, and the other subform is bound to
a tblEmployeeInspections, then you can put an unbound textbox control on the
main form, i'll call it txtID. set the control's ControlSource property to

=[SubformControlName].[Form]![EmployeeID]

(note: make sure you use the name of the *subform control* within the main
form, not the name of the subform form object in the database window -
sometimes the two names are different.)

click on the other subform control to select it. in the Properties box, set
the LinkChildFields property to the name of the EmployeeID foreign key field
from tblEmployeeInspections. set the LinkMasterFields property to [txtID].

btw, the tab control and the tab pages are irrelevant; they don't affect the
linking of the two subforms at all.

hth

I have searched and not sure if I am finding what I am looking for. I have
a form with two

[quoted text clipped - 19 lines]

Neal0o

 

[tina]

you're welcome

Tina,

Thank you... even though i didn't explain myself completely right you still
helped me solve my
problem... A big Thank you..

Neal0o

I am try'n to display
individual employee
information from two different forms linked via relationship "one to many"
EMPLOYEEID

I can not use the ...
to link the fields because they are all unbound forms.

i'm not following this. if the forms are unbound, then how are you
*displaying* employee and inspection data in them?

if one subform is bound to a tblEmployees, and the other subform is bound to
a tblEmployeeInspections, then you can put an unbound textbox control on the
main form, i'll call it txtID. set the control's ControlSource property to

=[SubformControlName].[Form]![EmployeeID]

(note: make sure you use the name of the *subform control* within the main
form, not the name of the subform form object in the database window -
sometimes the two names are different.)

click on the other subform control to select it. in the Properties box, set
the LinkChildFields property to the name of the EmployeeID foreign key field
from tblEmployeeInspections. set the LinkMasterFields property to [txtID].

btw, the tab control and the tab pages are irrelevant; they don't affect the
linking of the two subforms at all.

hth

I have searched and not sure if I am finding what I am looking for. I have
a form with two

[quoted text clipped - 19 lines]

Neal0o