J
Justin
I am looking to set-up a command button on a form to toggle the form between
Datasheet and Form View. Thank You for any assistance
Datasheet and Form View. Thank You for any assistance
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.
J
Jeff Conrad
To quote the all-powerful MVP Dirk Goldgar:
' Begin quote
Switch active form to datasheet view:
RunCommand acCmdDatasheetView
Switch active form to form view:
RunCommand acCmdFormView
To toggle the view:
Select Case Screen.ActiveForm.CurrentView
Case 1
' Currently in form view
RunCommand acCmdDatasheetView
Case 2
' Currently in datasheet view
RunCommand acCmdFormView
Case Else
' Must be design view (0) or some as yet undefined view
' Do nothing.
End Select
' End Quote
' Begin quote
Switch active form to datasheet view:
RunCommand acCmdDatasheetView
Switch active form to form view:
RunCommand acCmdFormView
To toggle the view:
Select Case Screen.ActiveForm.CurrentView
Case 1
' Currently in form view
RunCommand acCmdDatasheetView
Case 2
' Currently in datasheet view
RunCommand acCmdFormView
Case Else
' Must be design view (0) or some as yet undefined view
' Do nothing.
End Select
' End Quote
D
Dirk Goldgar
Justin said:I am looking to set-up a command button on a form to toggle the form
between Datasheet and Form View. Thank You for any assistance
See my reply to Howard, in this newsgroup, subject "Re: Change form's
view", dated Monday, November 15, 2004 7:53 PM (EST).
D
Dirk Goldgar
Jeff Conrad said:To quote the all-powerful MVP Dirk Goldgar:
ROFL Oh, my.
J
Jeff Conrad
Yes, Master.
;-)
;-)