I have created a hierarchical recordset to an Access DB that incorporates a main form with two datagrid subforms on the main form. The primary key in the main form is an autonumber field. The two subforms use that field as a foreign key. The problem is that when I add a new record to the main form the two subforms don't synchronize to the main form's primary key unless I close out of the project and get back into it. How can I synchronize the two subforms in code so that I can automatically enter data in them? Thanks in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Updating Hierarchical Recordset
- Thread starter Terpsfan
- Start date
