Switch nested sub to either datasheet, pivotTable or pivotChart view in Access 2007
Posted on 2008-11-17
I have a main form (aka Form3) with a sub form (aka Form2) in it and another sub form (aka Form1) in that. From the main form (aka Form3) I want to have the user be able to click a button in an option group and have it switch the view of the nested sub form (aka Form1) to the option they selected.
I tried using something like this:
but it seems to change the main forms view to datasheet rather than the nested sub. I've tried other variations, but only end up getting an error saying something about the command not being available at this time.