requery tabs subform data

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

Guest

I have a main form on which I have tab control with about 10 pages
in order to test and rerquery on page changes i put the following code

Private Sub TabCtl5_Change()

Select Case Me!TabCtl5
Case 1
Me![frmTB].Requery
Case 2
Me![frmAJE].Requery
case 3
Me![frminter co].Requery
End Select

End Sub

where case 1 is page 1 on the tab control and case 2 is the page 2
I get an error message when I move from page 1 to page 2 "form tb not found"

Can any please suggest how i correct the above code
Thanks
Danny.
 
Hi,


Is it possible your error is related to the fact that tablControl.Value
varies from ZERO to N-1, not from 1 to N ?


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top