relating subforms

[magmike]

The characters in this play are:

Main Form: ProspectForm
Tab Control: DetailTabs
Page in Tab Control: Contacts
Subform A on Contacts Tab: ContactList (a continuous form listing
limited details from contact records in the Contact table, relating to
the company record on the ProspectForm)
Subform B on Contacts Tab: ContactDetails

Image: http://www.benefitsolutions.cc/beta/contactdetail.htm

What I am trying to accomplish (perhaps in a bad way, i'm not sure) -
is to have the user click on a contact in the list (ContactList
subform - i.e. they click on "Shelbie F. Bateman") and have the full
details of that contact displayed in a second subform right next to it
(see image). However, I haven't been able to figure this out since the
subform wants to link to the main form.

help!

magmike

 

[Steve Schapel]

Magmike,

Put an unbound textbox on the main form, with Control Source set like this:
=[ContactList]![ContactID]
(... or whatever the name of your contact primary key field)
Let's say this textbox is named ContactRef.

Then, set the Link Master Fields and Link Child Fields properties of
the ContactDetails subform like this:
Master: ContactRef
Child: ContactID

 

[magmike]

Magmike,

Put an unbound textbox on the main form, with Control Source set like this:
=[ContactList]![ContactID]
(... or whatever the name of your contact primary key field)
Let's say this textbox is named ContactRef.

Then, set the Link Master Fields and Link Child Fields properties of
the ContactDetails subform like this:
Master: ContactRef
Child: ContactID

--
Steve Schapel, Microsoft Access MVP

The characters in this play are:

Main Form: ProspectForm
Tab Control: DetailTabs
Page in Tab Control: Contacts
Subform A on Contacts Tab: ContactList (a continuous form listing
limited details from contact records in the Contact table, relating to
the company record on the ProspectForm)
Subform B on Contacts Tab: ContactDetails

What I am trying to accomplish (perhaps in a bad way, i'm not sure) -
is to have the user click on a contact in the list (ContactList
subform - i.e. they click on "Shelbie F. Bateman") and have the full
details of that contact displayed in a second subform right next to it
(see image). However, I haven't been able to figure this out since the
subform wants to link to the main form.

magmike- Hide quoted text -

- Show quoted text -

Thanks! Works great!