synchronizing control values on subforms

[Gwen]

I have 2 subforms on my form. subform1 has a nested
subform.. When subform1 gets a new trackingid I want it
to automatically appear on subform2 trackingid control

I have attempted to at least append the new value into
the subform2 recordsource table.
Nothing happens.

I tried using code on subform1 control afterupdate event,
subform afterinsert, event, the mainform afterupdate.

Nothing happens.

What in the world am I doing wrong?

 

[Squirrel]

Hi Gwen,

If the trackingid is the primary key in subform1 and is a foreign key is
subform2 (ie. you have a one to many relationship set up via the trackingid
field) then all you'll need to do is open the properties dialog for the
control containing subform2 (not subform2 itself). The properties for the
control will allow you to enter values for 'Link Child Fields' and 'Link
Master Fields'. Enter trackingid into both values and then Access will
automatically populate the field for each new record in the child table.

HTH -Linda

 

[Gwen]

Thanks for your response

What I did was used an invisible text box with linking a
field from subform1. Which work, Thank God.

Now the the next challenge is to automatically get the
new tracking id from subform1 into subform2 and
synchronize the controls.

Thanks again!