Change subform default view with VBA

[JimN]

Can the default view (single form or continuous form) of a
subform be changed with VBA? I have a POS form with a
subform and according to the use, selected in the form by
the user, the subform default view should change.
Thanks,
Jim N

 

[MacDermott]

I've been able to change between single form and datasheet view
successfully, but not between single and continuous.

HTH
- Turtle

 

[Neil]

Jim,

AFAIK, the default view can only be changed in design view. I think the only
way to change it would be to close the form, open in design view and hide
the form (using DoCmd.OpenForm), close the form again - change the default
view first and save the changes, then reopen the form again.

HTH,

Neil.

 

[Guest]

Thanks for your response,
Jim

-----Original Message-----
I've been able to change between single form and datasheet view
successfully, but not between single and continuous.

HTH
- Turtle




.

 

[Guest]

Thanks for your response, I will try to come up with a
macro.
Jim