Using a dsn-less connection what is the correct syntax for updating 2 tables with the same connection.<BR><BR>As an example I have field1 from a form that gets added to table1 and field2 and field3 that get added to table2. Also; I want to write to field4 in table2 the auto-numbered ID field from field1 in table1 to field4 in table2.<BR><BR>Can anyone help me out? I have never tried to update 2 tables in one form before. Many thanks.