Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Each form, subform etc is connected to it's own data access - usually a table. Tables are independent of each other so adding records in one table doesn't trigger an add in another. Even using macros and other means, each table is independent and records added one at a time. Based upon your question, you can create a macro to save all three tables with one button but code will be necessary for each table involved.