Hello,
I have form with 5 different subforms. Each subforms links to its own table to update records. The reason we did this was to make it easier for our marketing group to update tables in one go basically. They have 5 tables they to update so they were pulling up 5 different forms. We put all those forms on to one form. Now all those forms have the same fields for product name, changes made, and notes and etc. The product is the same throughout the forms. Once the user is done making changes she hits save all and that one button calls five macros that updates the correct tables with respect to the correct subform. The problem we're having is this...Once the user picks a product from the "master list" it updates all the subforms product field which is fine that is what we want but the user won't necessarily make changes on all the forms. What we want to be able to do is this...once the user hits the "save all" button, we need it to search the one specific field in each subform and if it is empty we want it to delete that record from the table that subform is linked to.
Is this possible? I am sure it is but we can't figure it out for the life of us.
I have form with 5 different subforms. Each subforms links to its own table to update records. The reason we did this was to make it easier for our marketing group to update tables in one go basically. They have 5 tables they to update so they were pulling up 5 different forms. We put all those forms on to one form. Now all those forms have the same fields for product name, changes made, and notes and etc. The product is the same throughout the forms. Once the user is done making changes she hits save all and that one button calls five macros that updates the correct tables with respect to the correct subform. The problem we're having is this...Once the user picks a product from the "master list" it updates all the subforms product field which is fine that is what we want but the user won't necessarily make changes on all the forms. What we want to be able to do is this...once the user hits the "save all" button, we need it to search the one specific field in each subform and if it is empty we want it to delete that record from the table that subform is linked to.
Is this possible? I am sure it is but we can't figure it out for the life of us.
