Toggling between Form view & Datasheet view

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
 
J

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

Hi Darrel,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

toggling view in a subform 0
Switch between Datasheet and Form view 8
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Populate main form from subform record 0
Remote stopped working in PowerPoint Presenter View 0
main form/subform 1
Datasheet View and Runtime 5
Printing Outline view - formatting lost 0

Top