Hour glass not becoming visible

[aaj]

Hi all

can anyone tell me how to force the hourglass to appear on Access 2002 while
a form is loading up. I thought the following would work, but it doesn't,
the form loads up first.

on click event .....

DoCmd.Hourglass True
DoEvents
DoCmd.OpenForm "frm_to_open"

thanks

Andy

[Deano]

aaj wrote:

Hi all

can anyone tell me how to force the hourglass to appear on Access
2002 while a form is loading up. I thought the following would work,
but it doesn't, the form loads up first.

on click event .....

DoCmd.Hourglass True
DoEvents
DoCmd.OpenForm "frm_to_open"

thanks

Andy

How about putting DoCmd.Hourglass True in the open event of "frm_to_open"?

[aaj]

Hi Deano

tried this but also doesn't work. I've looked through some old google stuff
and it would seem lots of people have asked the question before, but as yet
I can't find any answers 8-(

Andy
"Deano" <ma**********@gmail.com> wrote in message
news:41***********************@ptn-nntp-reader01.plus.net...

aaj wrote:

Hi all

can anyone tell me how to force the hourglass to appear on Access
2002 while a form is loading up. I thought the following would work,
but it doesn't, the form loads up first.

on click event .....

DoCmd.Hourglass True
DoEvents
DoCmd.OpenForm "frm_to_open"

thanks

Andy

How about putting DoCmd.Hourglass True in the open event of "frm_to_open"?

[Deano]

aaj wrote:

Hi Deano

tried this but also doesn't work. I've looked through some old google
stuff and it would seem lots of people have asked the question
before, but as yet I can't find any answers 8-(

Andy

I just tried it with no problems on Access 2000. The form loads and the
hourglass remains busy since i haven't set it to False.
Sure you haven't got any code that's cancelling it inadvertently?