Database Version: 2013
Database setup: I have a vertical left Navigation Form with multiple tabs. Each tab has a form that is bound to its own table.
Problem: A user is entering data on one tab1, then clicks on tab2, the record from tab1 is stored with incomplete data
What I have tried: prompting a simple msgbox to fire on both the "NavigationForm>NavigationSubForm>MyForm" events and the "NavigationForm>NavigationSubform" events to find out where I could code the solution. It seems the order of events are not the same as a regular form/subform setup. So far the only one that seems to fire is the "NavigationSubform OnExit" event. But I cant seem to find a way to get the vba to reference the form inside the navigation subform container to test if its dirty and cancel the new record.
This is my first time posting in an access forum, be gentle