Opening forms in Data sheet view

[mmitchell]

I have a main menu that I select things to open. Most of the things I open I open in form view but some I want to open in data sheet view.

Without recoding my menu code is there a way to specify in the form to be opened that it should open in data sheet veiw?

Right now I have the default view as data sheet view in the forms but because my calling code is not specifying any view they default to form view, and again I don't want to edit that code in my main menu.

 

[ghudson]

DoCmd.OpenForm "YourForm", acFormDS

Search the access help files for the OpenForm command for more info for there are a lot of options.

 

[mmitchell]

DoCmd.OpenForm "YourForm", acFormDS

Thank, but no thanks.

That is not an option since the double click code in my menu would then open ALL the forms in data sheet view, not want I want.