Synchronising subform from another subform

[PeterW]

I have a form with a tab control with 2 tabs. Each tab control has a subform.
I want to synchronise the sumform on tab2 to the record in tab1.
name of form on tab1 is 'sbfrmQuotes' with a field 'QuoteNo'
name of form on tab2 is 'sbfrmQuoteComments' with linked field 'QuoteNo'
main form is called 'frmSalesQuotes'
I cannot get the second subform to synchronise with the first subform when I
move records on the first.
in the properties I have
link Child Fields as QuoteNo
link Master fields as Forms![frmSalesQuotes]![sbfrmQuotes]![QuoteNo]
It seems to work for first record but does not change when 1st record changes
I would be v grateful for any advice

 

[John W. Vinson]

I have a form with a tab control with 2 tabs. Each tab control has a subform.
I want to synchronise the sumform on tab2 to the record in tab1.
name of form on tab1 is 'sbfrmQuotes' with a field 'QuoteNo'
name of form on tab2 is 'sbfrmQuoteComments' with linked field 'QuoteNo'
main form is called 'frmSalesQuotes'
I cannot get the second subform to synchronise with the first subform when I
move records on the first.
in the properties I have
link Child Fields as QuoteNo
link Master fields as Forms![frmSalesQuotes]![sbfrmQuotes]![QuoteNo]
It seems to work for first record but does not change when 1st record changes
I would be v grateful for any advice

You'll need a "relay" textbox on the mainform. It can be invisible, but put a
textbox - txtRelay say - with

=[frmSalesQuotes]![sbfrmQuotes].Form![QuoteNo]

as its control source, and use [txtRelay] as the Master Link Field.

 

[PeterW]

Thank you once again
Works fine now

I have a form with a tab control with 2 tabs. Each tab control has a subform.
I want to synchronise the sumform on tab2 to the record in tab1.
name of form on tab1 is 'sbfrmQuotes' with a field 'QuoteNo'
name of form on tab2 is 'sbfrmQuoteComments' with linked field 'QuoteNo'
main form is called 'frmSalesQuotes'
I cannot get the second subform to synchronise with the first subform when I
move records on the first.
in the properties I have
link Child Fields as QuoteNo
link Master fields as Forms![frmSalesQuotes]![sbfrmQuotes]![QuoteNo]
It seems to work for first record but does not change when 1st record changes
I would be v grateful for any advice

You'll need a "relay" textbox on the mainform. It can be invisible, but put a
textbox - txtRelay say - with

=[frmSalesQuotes]![sbfrmQuotes].Form![QuoteNo]

as its control source, and use [txtRelay] as the Master Link Field.