Change form from Form View to Datasheet

[mguidry]

I would like to change the view of a form from regular Form View to the Datasheet view with a command button within the form. How do I do this?

 

[FancyPrairie]

Docmd.RunCommand acCmdDataSheetView

or

DoCmd.RunCommand acCmdFormView

 

[wdgriggs]

Private Sub cmdDatasheet_Click()
'***************** Code Start *******************
'This code was originally written by Terry Wickenden.
' It is not to be altered or distributed,
' except as part of an application.
' You are free to use it in any application,
' provided the copyright notice is left unchanged.

On Error GoTo ErrCmdDatasheet

Me.Log.SetFocus
DoCmd.RunCommand acCmdSubformDatasheet
If Me.cmdDatasheet.Caption = "Datasheet View" Then
Me.cmdDatasheet.Caption = "Form View"
Else
Me.cmdDatasheet.Caption = "Datasheet View"
End If
Exit Sub

ErrCmdDatasheet:
Select Case Err
Case 2046
'Datasheet view not available
MsgBox "This command not available at this time"
Exit Sub
Case Else
MsgBox Err.Number & vbCrLf & Err.Description
Exit Sub
End Select
End Sub

 

[wdgriggs]

Sorry! Posted before looking. Sent sub to change a subforms view. FancyPrarie was right.