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:

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???

Given that I don't know the "official names" of everything in 2007 products (they're still relatively new to me), I'm not sure what you mean by "Navigation Pane" nor what "it collapses" means to you.

By "trying to open the form itself," I assume you mean you go to your forms listing in the database and just open it (not in design view) vs. using the button and its VBA to open it.

What is it that you call the "Navigation Pane" and what do you mean by "it collapses"? Minimizes? Disappears?

It sounds like an event it firing or perhaps a macro is running upon opening of the form.

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division