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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Jim V said:
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.
Click to expand...

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
 
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.
 
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.
 
Back
Top