Linking subforms to separate tables

[Guest]

Problem ; I have two tables / One form with two subforms

I wish to link my subform to a separate table but it only allows one record
source. How can I link my tabular subforms to a separate table. For more
detailed please see as follows.

BR Photo Image Database

Table One = Form One which equals Image Information
Table Two = Subform which equals Description information
Table Three = Subform Number Two which equals Authors Comments

I type in the Form One all the generaql information in regards to the Photo.
This is not problem as it populates my Image Information Table.

The problem comes when i wish to type into Subform 2 or 3 as i am not
allowed to have more than one record source so it only gives me the option of
Table one's headings.

I wish to link these subforms to different tables in my database. How do i
do this?

 

[Rick Brandt]

Problem ; I have two tables / One form with two subforms

I wish to link my subform to a separate table but it only allows one
record source. How can I link my tabular subforms to a separate
table. For more detailed please see as follows.

BR Photo Image Database

Table One = Form One which equals Image Information
Table Two = Subform which equals Description information
Table Three = Subform Number Two which equals Authors Comments

I type in the Form One all the generaql information in regards to the
Photo. This is not problem as it populates my Image Information Table.

The problem comes when i wish to type into Subform 2 or 3 as i am not
allowed to have more than one record source so it only gives me the
option of Table one's headings.

I wish to link these subforms to different tables in my database. How
do i do this?

With actual subforms this is not a problem, but TabPages are not subforms. You
need to place subform controls onto the second and third TabPages.

 

[Guest]

Cheers Rick

But how do i place subform controls onto my tab pages

 

[Rick Brandt]

Cheers Rick

But how do i place subform controls onto my tab pages
"Rick Brandt" wrote:

Open your form in design view.
Select the desired TabPage
Drag a subform control from the toolbar
When over the TabPage (and it highlights) drop.
Set the SourceObject to the name of an existing form
Set the MasterLink and ChildLink properties

If the forms you need to use as subforms do not exist yet then you need to build
those first.