Hi,

I need help on making a timer for a set of action. After i click a
button, I want it to begin a timer, counting (up or down) to 20
seconds, then execute a Sub, or a query.

I tried to have a new form opened with the Timer and Timer interval in
that form, but it is not very good and i causes problems too. I think
doing loop is a much cleaner appoarch, but I can't seem to get it to
work.

Thanks,

V_

Hi V_,

Use the On Timer event to fire the new form, set your timer interval value
to 20000, then when the event fires, set your timer interval back to 0 so
that it doesn't fire again.

Damian.

"nxqviet" wrote:

> Hi,
>
> I need help on making a timer for a set of action. After i click a
> button, I want it to begin a timer, counting (up or down) to 20
> seconds, then execute a Sub, or a query.
>
> I tried to have a new form opened with the Timer and Timer interval in
> that form, but it is not very good and i causes problems too. I think
> doing loop is a much cleaner appoarch, but I can't seem to get it to
> work.
>
> Thanks,
>
> V_
>
>