Open Form in datasheet view

[Craig]

I created a form in datasheet view format. When I create a menu item in the
switchboard to open the form. I want it to open the form in datasheet view
not a form view.

How do I open the form in datasheet view from my menu in the switchboard??

 

[Arvin Meyer]

Two ways:

1. Set the default view of the form to Datasheeet.
2. Use code similar to:

DoCmd.OpenForm "FormName", acFormDS
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Unfortunately this is not an option directly from the switchboard manager. But, do not dispair. You can still do it. Create a macro (ugh!) to open the form. The datasheet view will be an option you can choose. Then from the switchboard manager, run the macro rather than opening the form directly.

 

[Craig]

Thanks for the quick reply. That did it.

Thanks from a newbie

Unfortunately this is not an option directly from the switchboard manager.

But, do not dispair. You can still do it. Create a macro (ugh!) to open
the form. The datasheet view will be an option you can choose. Then from
the switchboard manager, run the macro rather than opening the form
directly.