Is there a way of saving data records in a Form/SubForm/SubSubForm with a single click (except the obvious "Save" Button)? I know how to add a button action to save a record on a Form. However in some cases after entering data into a Form/SubForm there should be possibility of saving data with having to save data for each form separately.
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.
Since each circumstance is different, there is no one maco to cover all. It is totally dependent upon what is trying to be accomplished. Personally, I don't see any use for this. There are too many variables to account for. All my discoveries have come through meticulous examination using Xray and Mri.
Asked: 2016-05-28 19:58:09 +0100
Seen: 555 times
Last updated: May 29 '16
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
