Set Defaultview on Subforms

[systemx]

Hi there,

I am a complete Access newbie...so any help would be appreciated!

I have built a form containing three subforms all linked to the same query. On the form you can specify search criteria - and the subforms will requery based on these criteria.

One of the subforms is a datasheet view, the other two are intended to be pivotcharts. However, every time I reload the form, the view defaults to datasheet for all three subforms.

Is there a way to change the default view for a subform? I know you can do this with a form - but the controls do not seem to exist for a subform.

Thanks

Rob

EDIT:

Have sorted this out. Instead of using subforms based on the original subform, I have created standalone subforms based on the query. Set the defaultview for them...and bob's your mother's brother.