How to cancel an ongoing event?

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.
 
N

Neil

David,

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

Cheers!

Neil.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top