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

P

peanthony

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.
 
G

Guest

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.
 
Top