Hi hi hi!!<br><br>Sorry for so many questions, but this forum has been so far my only solution; I have a question regarding entering Data in Multiple tables using one Form:<br><br>How can I create a Form where I will be entering data in tables ( all common fields, except that each table is for a specific region) where in this form, I could like, for example, select in a combo Box, the table to where the data will be going, and then, just fill out the other fields and update the specific table chosen in the combo box??? Thanks again guys!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
USING A FORM TO ENTER DATA ON DIFFERENT TABLES
- Thread starter HerickP
- Start date
I would keep all the data in one table, but...<br><br>You can have code to change the Form's RecordSource and run this code in the ComboBox_AfterUpdate event. <p>Jim Conrad<br><a href=mailto:jconrad3@visteon.com>jconrad3@visteon.com</a><br><a href= > </a><br>
<br>Interesting approach, but well, why not.<br><br>I presume there will be a a value on the form that will determine which region that the record goes to; use an <b>append query</b> to stick the record in the correct table(s) prior to closing the form.<br><br><br><br><br><br><br> <p>Amiel<br><a href=mailto:amielzz@netscape.net>amielzz@netscape.net</a><br><a href= > </a><br>
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question