R
Rick's News
How do I make my Subform display in FormView vs Datasheet View?
Thanks In Advance!
Rick
Thanks In Advance!
Rick
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Sandra Daigle
The easiest way is to change the defaultView property in the property sheet.
From code you can use DoCmd.RunCommand acCmdSubformDatasheetView *after* you
setfocus to the subform control. Here's some sample code that goes in a
button click event for a button on the main form:
Private Sub Command16_Click()
Static fdatasheet As Boolean
Me.order_subform.SetFocus
If fdatasheet Then
DoCmd.RunCommand acCmdSubformDatasheetView
Else
DoCmd.RunCommand acCmdSubformFormView
End If
fdatasheet = Not fdatasheet
End Sub
From code you can use DoCmd.RunCommand acCmdSubformDatasheetView *after* you
setfocus to the subform control. Here's some sample code that goes in a
button click event for a button on the main form:
Private Sub Command16_Click()
Static fdatasheet As Boolean
Me.order_subform.SetFocus
If fdatasheet Then
DoCmd.RunCommand acCmdSubformDatasheetView
Else
DoCmd.RunCommand acCmdSubformFormView
End If
fdatasheet = Not fdatasheet
End Sub