in Access 2007, i am opening a form from a click on a button control - OnClick event.
the code supporting this is from an older Access 200 VBA module and it does the normal DoCmd.OpenForm command:
DoCmd.OpenForm stDocName, , , stLinkCriteria
When this gets issued, the Navigation Pane (tables/forms/etc...) collapses.
If i just try to open the form itself, same thing - Navi pane collapses.
I do the same operation using the Access 2007 method with embedded macro - same thing. NOTHING in OnLoad event.
I have another form that does the same thing - 2 forms out of 12+ forms in my app.
What is up with these two forms???