Hello all,

Anyone know of a way to launch a macro or module from an Access pivot table form? The idea is to use a pivot table in the way I use a regular form: to select a specific record to then view in detail in another form. If this is impossible, I might even be happy with figuring out a way to select a specific record from a pivot table view that can then be found when switched to its default form view. (Right now when I change views, the form view defaults to the first record in the underlying query regardless of what record was selected in the pivot table view.) Any suggestions would be greatly appreciated.

-TA