Open Form In Datasheet view?

[Wrecker]

How would I tell access to open a form in datasheet view". I'm assumming I should put the code in the "form open" module, but I'm having trouble with the code.

Thanks
Wrecker

 

[Susanne45]

Create a macro where Action = "Open Form" and in the "Action Arguments" section View = "Datasheet". Fill in the necessary info in the other Action Arguments.

Attach the macro to the on open function.

Susanne

 

[Maquis]

Wrecker, you don't need a macro or even VB code. Just set the default View property of the form to datasheet. Maq
<insert witty signature here>

 

[Wrecker]

If you open the form from the forms list it will open in Datasheet view. If you open the form using a command button it opens in form view.

Thanks
Wrecker

 

[Maquis]

Wrecker, what's the code used to open the form on the button? You can specify which mode to use when opening the form with the docmd.openform statement.

DoCmd.OpenForm &quot;form name here&quot;,acFormDS Maq
<insert witty signature here>