Hi,

I have a little problem with the forms I'm using when they have the pivottable view.

I made a custom toolbar to use in my database for navigation (instead of using the same action buttons on every form!) and it works fine on every form except the forms that have a pivottable view... What I first wanted to do then is to create an action button that makes me able to go back to the main menu when I press it, but the button does not appear when I use the pivottable view... There is also no button available like in a print preview that says 'close' or something like this that makes it easy to use...

Is there any way to create some VBA that when the user presses the 'escape' key, this pivottable form closes and the main menu opens again? I would like it to work like this, because the database will be used by people who never used Access before, so I want the application to be as easy to work with as possible.

thanks for any reply or suggestion on this problem...

If it is just a view, why not make it a report instead of a form? Just a thought.

mmcdonal

Because if I use the form, I can use the + and - on the form to show and hide the data I want...