Toggling between Form view & Datasheet view

[Mr. Moxie]

I have a Form that has a tabcontrol on it. On one of the tab pages, I have
a subform that I would like to be able to toggle between Form view &
Datasheet view (preferably by clicking a button on the tabpage).

Is there a command that will toggle the subform between the two view types?

Thank you in advance,
Darrel

 

[Jeff Conrad]

I have a Form that has a tabcontrol on it. On one of the tab pages, I have
a subform that I would like to be able to toggle between Form view &
Datasheet view (preferably by clicking a button on the tabpage).

Is there a command that will toggle the subform between the two view types?

Hi Darrel,

Private Sub ToggleView()
Me.SubfromControlNameHere.SetFocus
DoCmd.RunCommand acCmdSubformDatasheet
End Sub

 

[Mr. Moxie]

Awesome... Just what I was looking for Jeff.... Thanks again!

 

[Jeff Conrad]

Awesome... Just what I was looking for Jeff.... Thanks again!

You're very welcome, glad to help.