Changing subform's currentview

[arvindn]

I want to be able to change a subform to form-view / datasheet view when the main form is open in form view (not in design view) using VBA code preferably using the open event procedure of the main form. How can it be done?

 

[Oldsoftboss]

You can only change this property when the form is in design view.

Dave

 

[arvindn]

Thanks.

Any tricks to get around this ?

 

[Rich]

What's the purpose?

 

[arvindn]

The purpose is to allow a particular view (form/datasheet) of the subform based on the particular user's preference.