Form not opening in Datasheet view via the switchboard

[MSA]

I have a form that is to display a table in datasheet view. It works fine
when I click it directly i.e. it opens in datasheet view. Unfortunately when
I try to open it via the switchboard thru a button it opens the form in form
view. Could someone assist I think I might need to write "datasheet" in the
event procedure.

Thanks!
MSA

 

[Brendan Reynolds]

I have a form that is to display a table in datasheet view. It works fine
when I click it directly i.e. it opens in datasheet view. Unfortunately
when
I try to open it via the switchboard thru a button it opens the form in
form
view. Could someone assist I think I might need to write "datasheet" in
the
event procedure.

Thanks!
MSA

Note "acFormDS" below, this tells Access to open the form in datasheet view
....

Private Sub cmdTest_Click()
DoCmd.OpenForm "frmTest7", acFormDS
End Sub