Change Tab View based on Combo Box Value

[xcaliber2222]

Hello,

I have an Access 2003 app that has a tab control with a 3-table join query (QBE) as the data source. So, as you go through the 4 tabs you obviously see the same data. I have a combo box with two values (data source is a local lookup table). I would like to be able to switch to a different query based on this other value, sort of like a toggle switch so I can toggle back and forth between the views.

I'm not quite sure how to go about this. Any help would be greatly appreciated.

Thanks,
Alejandro

 

[TheAceMan1]

How are ya xcaliber2222 . . .

Make two queries and change the rowsource of the form to the query names alternately.


See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]