Button switches subform Datasheet --> Form view 1

[bgv]

How can I set up a button on a master form to switch a subform from datasheet view to form view and then back again?

 

[FancyPrairie]

Try this in the OnClick event of the button (Assume that the name of the subform control is form1)

Form1.SetFocus
DoCmd.RunCommand acCmdSubformDatasheet

 

[bgv]

Perfect! This is just what I needed.

Private Sub btnSwitchFormView_Click()
frmStationActivitiesListSubform.SetFocus
DoCmd.RunCommand acCmdSubformFormView
Me.btnSwitchDSView.Visible = True
Me.btnSwitchDSView.SetFocus
Me.btnSwitchFormView.Visible = False
End Sub

Private Sub btnSwitchDSView_Click()
frmStationActivitiesListSubform.SetFocus
DoCmd.RunCommand acCmdSubformDatasheetView
Me.btnSwitchFormView.Visible = True
Me.btnSwitchFormView.SetFocus
Me.btnSwitchDSView.Visible = False
End Sub


Thanks a lot. Learning more every day