I have a form with a tab control, multiple tabs.
Tab 1 and Tab 2 are just different data sheets against the same data (very wide data sheets).
I want to use a standard Access Filter on the first tab, and then when I click to go to the 2nd tab, I want that data sheet to filter to the same subset of records.
How do I get at Access system variables with Visual Basic so that I can set the 2nd tab to the same filter? ( I know I can design custom queries and use them between tabs, but I want the user to be able to use the system provided filter functions.)
Thank you in advance for any help you can give.