Switchboard ?s

JeffGirard · September 14th, 2005, 07:32 PM

Can I have a Switchboard button to open up a form in Datasheet view?
Also, can I have another button open a query?
Thanks a lot in advance.

JpJoe · September 15th, 2005, 02:52 AM

Hi ya,

Of course you can. Just use the docmd.openform method. You can then specify in what view you want the form opened. e.g

Code:

Private Sub cmdSwitchBoardButton1_Click()
    DoCmd.OpenForm "Your_Form", acFormDS
End Sub

The same applies to the query using docmd.openQuery,

Code:

Private Sub cmdSwitchBoardButton2_Click()
    DoCmd.OpenQuery "Your_Query", acViewNormal
End Sub

Good Luck.