troubleshooting Question

How to bypass AfterUpdate event of combo box when closing a form.

Avatar of JA67
JA67 asked on
Microsoft Access
82 Comments3 Solutions465 ViewsLast Modified:
If I input text into a combo box on my form and then close the form by clicking on the upper right hand corner "X", I get a runtime error. I believe the error is caused by the AfterUpdate event of this combo box trying to run while or after the form has closed; because if I do not type anything into this particular combo box I can close the form without error... So, how can I prevent the AfterUpdate code from running in this scenario?

Thank you!
JA67
ASKER CERTIFIED SOLUTION
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Database Architect / Application Developer
Join our community to see this answer!
Unlock 3 Answers and 82 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 82 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros