Tab Control / Hourglass Problem

[MattS]

I have a tab control which has many pages, most of which have subforms on. I have removed the tabs and control the page-change by using command buttons on the first page. The source objects of the subforms are set and requeried as part of a Select Case statement within the on_change event of the tab control. As this takes a little while I am trying to force the hourglass using DoCmd.Hourglass True/False.

My problem is that I simply can NOT get it to work. I have tried putting the Hourglass code on the command buttons that change the page, within the procedure I call to change the page, and even in the on_change event of the tab control. Nothing.

This isn't of high importance, but is still VERY annoying!!

Any assistance would be greatly appreciated.

Thanks,

Matt.

PS: My first post - so Hi to everybody on the board.

 

[indesisiv]

DoCmd.Hourglass True
DoCmd.Hourglass False

Seem to work fine for me.

 

[MattS]

Issue now resolved, although I don't fully understand why.

I have placed the DoCmd.Hourglass True/False statements within the on_change procedure of the tab control.

I was actually using images on the first page, not command buttons, and the hourglass would not appear. By placing transparent command buttons over the images, and calling the change page routine from there, it works. Not sure why - maybe something do with Focus??

Thanks,

Matt.