AboutRichard Rost Expertise I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site.
Education/Credentials I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at 599CD.com
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.
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.
