Debbie
delam at zyterra.com
Wed Oct 6 16:53:18 CDT 2010
I have a form in access 2007 that has a lot of code that runs when certain events happen. These take several seconds to complete and occasionally if a user changes thier mind or gets impatient and clicks elsewhere before the code finishes I get errors and problems. For example: I have an option box that shows or hides various subforms. Click between then quickly and before too long you will get stuck on one option and can't change it without changing something else in the form then going back. Still doing my best to educate fast clicking out of them, especially on this form, but ideally I need some way to keep new entry from happening while code is running. I have just experimented with an inconspicuous modal form that opens on code firing and closes when it is done, but still get the option button sticking. Either I need a different solution, or the problem is not what I think it is. Anyone have any ideas? Debbie Sent from my iPhone