How do I set acformview to datasheet in VB docmd.openform in acce.

[Guest]

Access event procedure using docmd.openform to launch a form. i want it to
start out in datasheet view and set the form default. however, the form opens
in single form view.

how do i change that to datasheet view?

 

[kingston via AccessMonster.com]

Did you try using the option acFormDS in your DoCmd statement? To set the
form default view, open the form in design mode and set it in the form's
Property window.