tabs - requery on tab changes

[Guest]

How do you requery sub forms on moving from one tab page to another tab page.

Thanks
Danny

 

[Rick Brandt]

How do you requery sub forms on moving from one tab page to another tab page.

In the Change Event of the TabControl...

Select Case Me.TabControlName.Value
Case 0
Me.SubformControlOnPage1.Requery
Case 1
Me.SubformControlOnPage2.Requery
End Select

 

[Guest]

Thanks Rick

I also have a problem on the layout of a report - the report is for
presenting Financal statements both Balance sheet and Income Statment for
current period and comparative period so need 2 column

I have a query based on 3 tables - The query has about 15 items for the
balance sheet and 15 line items for the income statement - for both I will
need to group approx 5 items and 1 page will have 3 grouping -so each page
will have approx 15 line items (records 5*3) in between the 3 grouping I will
need to add either text boxes or sub total.

Seems rather complex - but I thought i check with you if you have come
across similar problems .

Thanks a lot Danny