Update two tables with one form

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

Guest

I set up a new form which is supposed to update two separate tables at the
same time. The two tables are linked by the primary key called, keycode,
which is the only bit of information that the two tables share.

Is there a way to enter the keycode information once on the form so both
tables are updated with this along with the other information on the form? I
tried to build an update query to do this, but I keep getting error messages
when I try to save it.
 
GUESSING since I use the Update Querry alot....

I think you will have to have 2 update queries and run them from a command
button or something to update different tables this way....

Hope it works for you..

diwght
 
You must log in or register to reply here.

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

Update Two Tables Using One Form Contents 0
Restrict entering Null or Empty in Textbox - Access 2007 0
Separate Form 0
Can a form linked to an autoLookup query update another table 1
Update Table Value Based Upon Form Entry 1
Form needs to update two tables then ... 1
Update table when entry is saved 10
Access 2010 Form Issue's 0

Back
Top