Where to put Requery code so it runs on click of Tab?

[kirstenlargent]

I have a form with several tabs on it. I would like the form to Requery a specific query when I click on a certain tab. I tried putting the code in the "On Click" event of the tab, but it won't run. Where should I put the code?

Thanks!

 

[PHV]

I'd try the Change event.
Tip: the Value of a TabControl is the index (0 based) in the Pages collection.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886