How to cancel an ongoing event?

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

I have a form that in its on open event, imports all fields from a few
tables into a listbox. This can take upto 30 seconds or more (depending on
which computer I am using). What I would like to do is open another form
(like a dialog window) with a progress bar on it and a cancel button. I know
how to code everything apart from 1 thing.

In the OnClick event of the cancel button on the dialog form, how can i stop
the main forms OnLoad event from processing?

TIA,

Neil.
 
David,

I thought that may be the case but wasn't too sure how to use DoEvents.

Cheers!

Neil.
 
Back
Top