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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multi-Select 0
Form for Parts-Tools Lists 0
Multi-Table query data source won't allow edits in Form 7
Cannot edit data in forms but can in tables 2
Multi Value Combo Boxes 4
Editing data in a form that is linked to multiple source tables 1
How to use multiple command button to copy user form data to multiple worksheet 0
Form with Multiple Tables 1

Back
Top