I have a Navigation Form that has multiple main tabs across and then multiple sub tabs below each main tab.
I find that sometimes the Navigation Target Name changes for the sub tabs. I have tried to think of how to catch when it is happening, but it seems very random. It seems Access just chooses another form in the database to display - which I know sounds bizarre and therefore there has to be a reason. It does not change the reference for the form I edit, it doesn't seem to be because I open a form outside of the navigation form, it's not after adding a new form. I can be out of the database for a while, come back and find it's switched the references.
I created the tabs and buttons using two different methods - I changed after this started happening hoping it would make a difference, which it did not. The names change for any button randomly, not just the ones created using just one of the ways.
The first way I typed the form's name in the "[Add New]" button.
The second way I selected the form's name from the drop down box attached to the Navigation Target Name field in the Property Sheet pane.
Has anyone else had this trouble? I cannot find anything on the internet that references this. Intermittent problems are the worst.