Toggle Subforms to Datasheet View

Stang70Fastback

Registered User.
Local time
Today, 15:50
Joined
Dec 24, 2012
Messages
132
Hey guys, I think this is a relatively simple problem... we shall see.

Let's say I have a form. On this form is a tab control with 5 tabs. Four of these tabs have subforms on them. The 5th tab is sort of a "settings" page. What I would like to do is have a button on the 5th tab, that toggles the subforms on the other four pages between the regular form view, and datasheet view.

I know I can use the "DoCmd.RunCommand acCmdSubformDatasheet" to do this, however I am unsure as to how to apply it to the subforms on the other tabs. They aren't "in focus" so the command won't work properly. How can I go about doing this?
 
Nevermind guys! Turns out what I was doing was right, but the form's properties had "Allow Datasheet View" set to 'No'.
 

Users who are viewing this thread

Back
Top Bottom