Expert: Richard Rost - 2/11/2008

Question
I need two tables open from a single form. The 1st table data is entered via a command button. I need to update a second table based on the 1st table inputs.  How do I do this?

Answer
I don't know what you mean. Can you be a little more specific? You're opening up two tables from a form (with a button?) The user types data into table 1 and then you need to change values in table 2 from the data in table 1?

The easiest way to do it would be to have ONE form (bound to table 1) open where the data is entered into (thereby putting the data in table 1) and then when you're done (perhaps the AfterUpdate event) change the data you need in table 2.



Let me know if you have any more questions or comments.

Cordially,

Richard Rost
President/CEO
599CD Computer Training
http://www.599cd.com/Microsoft_Access_Tutorial


P.S. Come and try one of my ACCESS TUTORIAL VIDEO LESSONS on my web site FREE. Just use this link. http://www.599cd.com?AEXAC

P.P.S. Remember, I volunteer my time at AllExperts to help people, so I can't take 20 minutes to answer each question. If you need more DETAILED HELP, come to my TechHelp web site at http://www.599cd.com/TechHelp and I'll take as much time as you need to answer your question.