Toggling between Form view & Datasheet view

  • Thread starter Thread starter Mr. Moxie
  • Start date Start date
M

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
 
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?
Click to expand...

Hi Darrel,

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