tabs - requery on tab changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thanks
Danny
 
Danny said:
How do you requery sub forms on moving from one tab page to another tab page.
Click to expand...

In the Change Event of the TabControl...

Select Case Me.TabControlName.Value
Case 0
Me.SubformControlOnPage1.Requery
Case 1
Me.SubformControlOnPage2.Requery
End Select
 
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
 
Back
Top