Hi
I am using ghudson's better mousetrap code in a DB I am working on at the moment and it is working great. What a great piece of code.
I have one form in my DB that has a subform. I want to use the mousetrap code in the parent form to stop the user navigating through records with the mousewheel, and also to confirm saving any changes.
I only want the user to have to save the records once the related records are added in the subform - so they don't have to save twice.
In other words not to ask the user to save when they click on the subform to enter the related records. Only ask them if they want to save if they either; add a new record on the parent form, try to navigate away from the curent record or close the form.
Another thing I should mention is that every record entered on the parent form requires related records to be entered in the subform. I already check this has been done in my code to save the record on the parent form.
Any help or suggestions would be greatly appreciated.
Thanks
Jubb
I am using ghudson's better mousetrap code in a DB I am working on at the moment and it is working great. What a great piece of code.
I have one form in my DB that has a subform. I want to use the mousetrap code in the parent form to stop the user navigating through records with the mousewheel, and also to confirm saving any changes.
I only want the user to have to save the records once the related records are added in the subform - so they don't have to save twice.
In other words not to ask the user to save when they click on the subform to enter the related records. Only ask them if they want to save if they either; add a new record on the parent form, try to navigate away from the curent record or close the form.
Another thing I should mention is that every record entered on the parent form requires related records to be entered in the subform. I already check this has been done in my code to save the record on the parent form.
Any help or suggestions would be greatly appreciated.
Thanks
Jubb
