Click event of form?

[BLFOSTER]

I would like to display a msgbox that tells the user a query is still opening if the user clicks around the form while waiting.....is this doable?

[June7]

Cannot open msgbox while other process is running.

Can try changing the cursor to an hourglass before the code that opens query then change it back after. Or make a label with message visible before then not visible after.

A query takes that long to open?

[BLFOSTER]

Oh I see...thank you! Yes this query is counting and takes about 30-45 seconds to open. People can get real impatient

[ranman256]

I usu. have a label (normally invisible) but when they click the button, A Big Red label appears and says "processing..." (hrglass too).
This way they KNOW its running.