excel tabs

[madrav72]

hi

is there a way to display an excel looking sheet into a form which displays different tabs for each query that i want to output

or is it easier to just output the data to excel into different tabs??


thanks

 

[llkhoutx]

Add a tabbed control with a subform datasheets with appropriate query recordsource on each.

You won't want to constantly simul;taneously requery each, so hide the tabs and replace then with bttons which opens the appropriate tab and requeries the appropriate datasheet.

 

[boblarson]

Hey llkhoutx

You don't need to hide the tabs and add buttons. You can use the Change event on the tab control to determine which tab was chosen.

For example:

Private Sub TabCtl_Change()
    Select Case TabCtl
        Case 0
            Put 1st Tab's requery code here
        Case 1
            Put 2nd Tab's requery code here
    End Select
End Sub