Tab strips on a form

[Mcgrco]

please can someone help!

I have two tabs on a form. The first tab contains a subform and the second tab contains two sub forms which are based on the first tabs subform. What is supposed to happen is when the user selects a row of data on the first tab it populates some text boxs.The subforms on tab2 are based on these text boxs. What i can seems to do is requery the ssubforms on tab2 when i click on the tab. The only way I can get this to work is to put the requery property on the enter event of one of tab2's subforms. this is obviously not ideal . Does anyone knwo the correct event to query tab2's subforms on clicking the tab2.

Many thanks

 

[crosmill]

i had a similar problem the last time I used Tabbed forms, I found that there just isn't a property for the individual tabs, but that was a while ago and using 97. I'm not sure if that is still the case.

There are other ways around it though, chakc out the event properties, onFocus onLostFocus maybe, there should be a way to get it do what you want.

 

[Mcgrco]

Cheers Managed to get it to work by setting the focus on the tab click to a command button. This then triggers the requery on the subforms. Strange that there is no other way around it but hey it works.

thank you for your help