Force cancel button to respond

[pjh172]

I have a split database that pulls info from several tables from a server at a remote office over our intranet. This takes a bit of time to accomplish, so I created a simple form that tells the user that Access is pulling the info they need (otherwise they think nothing is happening). I've placed a cancel button on the form with code to quit the application if the user gets tired of waiting. However...I can't get the cancel button to respond. Access will not respond until it has pulled all the info from the tables over our intranet. How do I make the cancel button work?

Thanks.

 

[CaptainD]

You can use "doevents". Might want to look into different ways of implimenting it.

You can search this site and check out the link below.

http://techrepublic.com.com/5208-10878-0.html?forumID=87&threadID=173710&messageID=1767403