Toggle between Views?

[PennWhite]

Does anyone know if it is possible to use a 'toggle' button to switch between form view and datasheet view for a form? I've tried working with docmd and with a macro openview but neither seem to work. I can do it from the View option on the Menubar but can't figure it out programatically.

Thank you,

Penn

 

[HitechUser]

PennWhite,

Have a look here

View

This should do it...

 

[PennWhite]

Cool. Thank you very much!

Penn

 

[FancyPrairie]

This switches it to Datasheet view:
DoCmd.RunCommand (acCmdDatasheetView)

And this switches it to Form View:
Docmd.RunCommand (acCmdFormView)