Form Field to 2 Subforms to store in Table?

[Brook]

Good Day,

I have the following: frminvoices, frminvoicepayments subform &
frminvoicedetails subform. On my frminvoices, I have my invoicenumber. After
this number is updated, I would like to "copy" this invoice number to both my
field InvoiceNumber in my frminvoicepayments subform & frminvoicedetails
subform. I would like to be able to store these fields within my
tblinvoicepayments & tlbinvoicedetails?

how would I go about doing this?

Thanks,

Brook

 

[Tara Johnson]

When you click on your SubForm, in the Properties, under the Data Tab, you
should see Link Child Fields and Link Master Fields. This is where you will
enter the fields that you want linked to each other. This should transfer
the information from the Master (the main form) to the Child (the subform).

If there is someone who can add to or further explain what I am trying to
say, please feel free...

HTH,
Tara

 

[Brook]

Tara,

Thanks for the response, I don't see the option "Link Child Fields" &
"Link Master Fields" when I open my subform, then click properties these are
the only options that I see:

Record Source
Filter
Order On
Allow Filters
Allow Edits
Allow Deletions
Allow Additions
Data Entry
RecordSet type
Record Locks
Fetch Defaults


Any Ideas why I wouldn't see the Link Child & Link Master?

Thanks,

Brook

 

[Tara Johnson]

You may be clicking just on the "Detail" area of the Subform. Look at the
top of the Properties window - it should say
"Subform/Subreport:[YourSubformNameHere]. If it says something else, you
probably haven't selected the Subform itself, so not all the properties will
be there.

--Tara

 

[Brook]

Tara,

I clicked in the top left corner of the form where it shows a small black
box, then right click properies.

At the top of window is says frminvoicedetails_subform: Form.

Did I set something up wrong?

Thanks,

Brook

You may be clicking just on the "Detail" area of the Subform. Look at the
top of the Properties window - it should say
"Subform/Subreport:[YourSubformNameHere]. If it says something else, you
probably haven't selected the Subform itself, so not all the properties will
be there.

--Tara
--
main email is tara.e.johnson at gmail dot com

Tara,

Thanks for the response, I don't see the option "Link Child Fields" &
"Link Master Fields" when I open my subform, then click properties these are
the only options that I see:

Record Source
Filter
Order On
Allow Filters
Allow Edits
Allow Deletions
Allow Additions
Data Entry
RecordSet type
Record Locks
Fetch Defaults


Any Ideas why I wouldn't see the Link Child & Link Master?

Thanks,

Brook

 

[Brook]

Tara,

I was going through my forms list and going straight into my
frminvoicedeteails subform.

I opened my frminvoices, then my suform and found my properties for the
link child field

thanks for your help!

Brook

You may be clicking just on the "Detail" area of the Subform. Look at the
top of the Properties window - it should say
"Subform/Subreport:[YourSubformNameHere]. If it says something else, you
probably haven't selected the Subform itself, so not all the properties will
be there.

--Tara
--
main email is tara.e.johnson at gmail dot com

Tara,

Thanks for the response, I don't see the option "Link Child Fields" &
"Link Master Fields" when I open my subform, then click properties these are
the only options that I see:

Record Source
Filter
Order On
Allow Filters
Allow Edits
Allow Deletions
Allow Additions
Data Entry
RecordSet type
Record Locks
Fetch Defaults


Any Ideas why I wouldn't see the Link Child & Link Master?

Thanks,

Brook