subform2 - Dynamically synchronizing new record on control

[Gwen]

Hi,

I have 2 subforms on a main form

subform1 has a nested form subform1a

subform1 displays call details info such as time, call
taken by etc.
subform2 has the call description info issue1, issue2 and
so on.

subform2 has the call solution info


When a new record is added to subform1 I want the new
trackingid number to automatically be added to subform2.

I am thinking along these lines: appending the new
tracking id number to using code to the table? If this is
logical thinking, On what event should I put the code?
How do I synchonize the controls to reflect the new
trackingid on subform2

Please assist.


Thanks

Gwen

 

[Marshall Barton]

I have 2 subforms on a main form

subform1 has a nested form subform1a

subform1 displays call details info such as time, call
taken by etc.
subform2 has the call description info issue1, issue2 and
so on.

subform2 has the call solution info


When a new record is added to subform1 I want the new
trackingid number to automatically be added to subform2.

I am thinking along these lines: appending the new
tracking id number to using code to the table? If this is
logical thinking, On what event should I put the code?
How do I synchonize the controls to reflect the new
trackingid on subform2

Using your invisible text box as the second subform
control's Link Master property and the trackingid field as
the Link Child property should fill in the value
automatically.