Synchronising subform from another subform

  • Thread starter Thread starter PeterW
  • Start date Start date
P

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

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.
 
Thank you once again
Works fine now

John W. Vinson said:
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
Click to expand...

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