Main form with two subforms on it and linked to it

Hi, is it possible to have a main form with two subforms linked to that main
form. Each subform has a parent/child relationship with the main form. Each
subform comes from a separate table which is linked to the main forms table
with a one/many relationship. The subform tables are on the many side.

I have a Venue table with a one/many relationship to the Contacts and
Violations tables. They are linked by VenueID. I would like a main form with
each subform on its own tabcontrol on the main form.

Can I do this?

Thanks
Tom

--
Message posted via http://www.accessmonster.com

yes. build the main form, including the tab control. build a form for the
Contacts table, and another form for the Violations table. open the main
form in design view, and select the first tab page. in the Toolbox toolbar,
click the Subform/Subreport button, then click anywhere within the tab page
to place the control on the page. in the Properties box, click on the
SourceObject line and click the down arrow at the right. select the name of
the Contacts form from the droplist. set the LinkMasterFields property to
the name of the Venues primary key field. set the LinkChildFields property
to the name of the matching foreign key field in the Contacts table. (if you
linked the tables properly in the Relationships window, Access may set these
two properties automatically.)

repeat the above, to create the Violations subform.

hth


"Tom K via AccessMonster.com" u9562@uwe wrote in message
news:58b26d1000f74@uwe...
Hi, is it possible to have a main form with two subforms linked to that
main
form. Each subform has a parent/child relationship with the main form.
Each
subform comes from a separate table which is linked to the main forms
table
with a one/many relationship. The subform tables are on the many side.

I have a Venue table with a one/many relationship to the Contacts and
Violations tables. They are linked by VenueID. I would like a main form
with
each subform on its own tabcontrol on the main form.

Can I do this?

Thanks
Tom

--
Message posted via http://www.accessmonster.com

Thank you very much!

Tom

tina wrote:
yes. build the main form, including the tab control. build a form for the
Contacts table, and another form for the Violations table. open the main
form in design view, and select the first tab page. in the Toolbox toolbar,
click the Subform/Subreport button, then click anywhere within the tab page
to place the control on the page. in the Properties box, click on the
SourceObject line and click the down arrow at the right. select the name of
the Contacts form from the droplist. set the LinkMasterFields property to
the name of the Venues primary key field. set the LinkChildFields property
to the name of the matching foreign key field in the Contacts table. (if you
linked the tables properly in the Relationships window, Access may set these
two properties automatically.)

repeat the above, to create the Violations subform.

hth

Hi, is it possible to have a main form with two subforms linked to that main
form. Each subform has a parent/child relationship with the main form. Each
[quoted text clipped - 9 lines]
Thanks
Tom

--
Message posted via http://www.accessmonster.com

you're welcome


"Tom K via AccessMonster.com" u9562@uwe wrote in message
news:58b46e174ad40@uwe...
Thank you very much!

Tom

tina wrote:
yes. build the main form, including the tab control. build a form for the
Contacts table, and another form for the Violations table. open the main
form in design view, and select the first tab page. in the Toolbox
toolbar,
click the Subform/Subreport button, then click anywhere within the tab
page
to place the control on the page. in the Properties box, click on the
SourceObject line and click the down arrow at the right. select the name
of
the Contacts form from the droplist. set the LinkMasterFields property to
the name of the Venues primary key field. set the LinkChildFields
property
to the name of the matching foreign key field in the Contacts table. (if
you
linked the tables properly in the Relationships window, Access may set
these
two properties automatically.)

repeat the above, to create the Violations subform.

hth

Hi, is it possible to have a main form with two subforms linked to that
main
form. Each subform has a parent/child relationship with the main form.
Each
[quoted text clipped - 9 lines]
Thanks
Tom

--
Message posted via http://www.accessmonster.com