I have a subform which is displayed as a single form. I want to make a command button that can display it in datasheet view without having to right-click on the subform itself.

What should the codes be in the event procedure? Thanks

put a button on the subform.
onclick -
DoCmd.RunCommand acCmdSubformDatasheet

pdx_man,

That works fine, but what if I wanted to toggle back to single view from datasheet view? Is it possible to create a button on the main form itself to toggle between views?