Form Field to 2 Subforms to store in Table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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
 
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

Tara Johnson said:
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


Brook said:
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
Click to expand...
Click to expand...
 
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

Tara Johnson said:
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


Brook said:
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
Click to expand...
Click to expand...
 
Back
Top