hi,
each table would have to be updated seperatly. You would
have to call the data to a temp table and use the temp
table as the forms record sorce. from there you could use
an update query, 1 for each table, that updates the tables
from the temptable and run them in succession or a series
of recordsets that update the tables.