Form not opening in Datasheet view via the switchboard

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MSA - 23 Jan 2008 01:23 GMT

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

Reply to this Message

Brendan Reynolds - 23 Jan 2008 11:31 GMT

>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
[quoted text clipped - 7 lines]
> 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

Signature

Brendan Reynolds

Reply to this Message