How do you edit data in a form that uses multiple tables?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to work with a form that uses multiple tables. Access Forms is
not allowing me to make any edits to the data.
 
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.
 
Back
Top