Form not opening in Datasheet view via the switchboard

  • Thread starter Thread starter MSA
  • Start date Start date
M

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


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

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