View>Subform>Pivot table

[trvk123]

I am trying to use this old menu path in Aceess 2007. Is there any way I can do it? When I click View>Pivot table menu in 2007, it is displaying the main form. But, my data is in the sub form. Any help is appreciated.

 

[Adzi]

Have you made sure that the sub form properties for Allow view PivotTable are set to yes? Simple I know but you'd be supprised how many people forget

 

[trvk123]

Yes, I checked the properties of the Sub form and the Pivot Table view is said to Yes. Thank you for your post, please post the menu path you use to view the Pivot table of the Sub Form.

 

[trvk123]

Yes, I checked the properties of the Sub form and the Pivot Table view is set to Yes. Thank you for your post, please post the menu path you use to view the Pivot table of the Sub Form.