I created the attached db
I need to automatically update the details table from the main table...
I know this is extremely basic but Im using an ado connection form vb
and am having problems synchronizing the table with 2 seperate ado connections
Sounds like you need to create a table relationship between the two tables first. With this in place you won't need to syncronize with code. I.E. when you add a detail record in a subform bound to a detail table embedded in a main form bound to a header table the id's from the header record will automatically populate down to the detail record.
The relationship screen can be accessed from the database window via a button on the toolbar.