Fun with subform defaultview

[systemx]

Hi there,

I am having a frustrating time trying to set the defaultview for a subform to 'Form' view.

When I try to set the defaultview I get a runtime 2136 error - as this has to be done from design view.

So on the mainform I have set a 'Form Load' event that attempts to open the subform in design view, make the change to the defaultview property - then close the form.

Now I get the error msg "You cannot open a subform while it is open in design view".

I get the same error when setting this is an open form event.

Google has not provided a solution for my problem Can anyone here shed some light?

Thanks in advance

/Me

 

[RuralGuy]

Why do you feel compelled to change the default view at run time?

 

[systemx]

Hey Rural Guy,

Basically, I want the subform to always default to 'Form' view. I have set the properties of the subform - so that only form view is allowed. However, when the mainform is started, the subform always defaults to datasheet view.

Cheers

Rob

 

[RuralGuy]

I know this is a stupid question but how have you set the DefaultView of the SubForm?