Change subform default view with VBA

  • Thread starter Thread starter JimN
  • Start date Start date
J

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
 
I've been able to change between single form and datasheet view
successfully, but not between single and continuous.

HTH
- Turtle
 
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.
 
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




.
Click to expand...
 
Back
Top