How I open a form in datasheet view from a switchboard menu?

[Guest]

I am having troble opening a from in datasheet view from the switchboard
menu. I have already set the default veiw in the form propreties to
datasheet but the form still opens in form view.

 

[Arvin Meyer]

I am having troble opening a from in datasheet view from the switchboard
menu. I have already set the default veiw in the form propreties to
datasheet but the form still opens in form view.

A single line of code should do it:

DoCmd.OpenForm "frmYourForm", acFormDS


acFormDS tells the form to open in datasheet view.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Van T. Dinh]

If you are talking about the in-built Switchboard, open Form in
DatasheetView is not an option.

You need to use the RunCode command to run a code and the code is like what
Arvin posted.

 

[Guest]

I've done this before. You can set up a macro to open the form in datasheet
view. Then in the switchboard program the buttons so that it opens the macro
rather than the form.

 

[Jeff Conrad]

See this page on my site for any and all SBM questions:

http://home.bendbroadband.com/conradsystems/accessjunkie/switchboardfaq.html

In your particular case, this spot:

http://home.bendbroadband.com/conradsystems/accessjunkie/switchboardfaq.html#datasheet

(Watch out for any line wrapping on the links)

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message: