VB Test for which tabbed page is active on a form

[Tfrank]

I have a form that contains tabbed page forms. I have a simple question, is there a simple test using VB that I can do that will tell me which tabbed page is selected for view by the user. On one tab page I display photo's but I would only like to update each record with the appropiate photo when that specific tab is selected. The proccess is slow for some picures that are large. So this is why I only won't to update it when neccessary.

Thanks for the help,
TFrank

 

[KenReay]

Hi

Sure is

TabCtl.Value

First page is 0, second page is 1 etc

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[wphsp]

Not sure if this will help you but have the subform on the tab unbound and make it invisible. then use the following code, but you

Private Sub TabCtl0_Change()
Select Case TabCtl0.Pages.Item(TabCtl0.Value).Name

'Case "pg1"
' If Len(sfrm1.SourceObject) = 0 Then
' sfrm1.SourceObject = "sfrm1"
sfrm1.LinkChildFields = "ID"
' sfrm1.LinkMasterFields = "ID"
' sfrm1.Visible = True
' End If
You can omit the link child fields. This will speed up the process.