I have a form with like 20 fields that are combo and text boxes. There is an "Add Record" button at the bottom. I need the info. that is entered on the form to be saved into 2 seperate tables (some fields go to one and the rest to the other). Does anybody know what I need to do? Thanks in advance for any help!!
Save Record
- Thread starter DeeDee77
- Start date
- Local time
- Today, 09:45
- Joined
- Feb 28, 2001
- Messages
- 30,495
Well, the SIMPLE method is, if the tables are related to each other (yes, a formal relationship type "related to each other") and it makes sense to build a query that is the JOIN of the tables, make your form work off the query instead of either table.
If the relationship is more like parent/child, if the form is set up as form/subform (corresponding to parent/child), that will ALSO be an automatic save.
If neither of these situations apply, you might have to end up writing some VBA code.
In which case the form just got LOTS more complicated.
If the relationship is more like parent/child, if the form is set up as form/subform (corresponding to parent/child), that will ALSO be an automatic save.
If neither of these situations apply, you might have to end up writing some VBA code.
In which case the form just got LOTS more complicated.
