Help with Datasheet view

[Kelly S.]

I have a WaterAccounts form which I have not allowed any
views except "Datasheet" view. (Assigned "NO" to the
other views and "Datasheet" as the default view.) (I
prefer this view for this information.)

This works great when I open the form directly from the
Database window under FORMS. I have another form that
contains a command button to this same WaterAccounts
form. When I click on the command button, the "Form"
view appears every time and all the other views are
allowed somehow. I have to click on the 'views' button on
the toolbar to switch to "Datasheet" view.

How can I keep the "Datasheet" view when I open the form
from a command button?

Thanks in advance!!

 

[Allen Browne]

Specify Datasheet for the View paramet of OpenForm:
DoCmd.OpenForm "myForm", acFormDS