Linked fields don't auto populated on subforms

[carlcwc]

I have created a main form with a tab subform. On each tab is a subform. Each subform has the ClientID field linked. The main form and the first subform use the same mother table as the record source. The other subforms use child tables with the ClientID (text field) as the linked field. What I want to see happen is that when the first subform is filled, then the ClientID autofills on the other subforms in the ClientID field.
I've tried inserting a "refresh" code but that doesn't work.
Your help on this matter is most appreciated.

 

[JeremyNYC]

Are you saying that you want records appended to the other tables when you append a record to one of the tables, via one of the subforms? I think that's what it would take. I would think carefully about this. You may end up with a bunch of blank records. If you really do want to go ahead with this (assuming I'm not totally misunderstanding what you want to do), put code in the afterInsert event of each of the subforms that you want to trigger this. This code will put some bit of data in each of the other subforms, creating the new, properly linked records.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.