Home > Access 2010 > Access 2010 Runtime Error 2115

Access 2010 Runtime Error 2115

Is there some way to make it work with the combo box BeforeUpdate event so that it validates when I click in another control? (something like the following, adapted from your Your name or email address: Do you already have an account? Curious Modules & VBA 2 08-23-2007 05:26 PM Using Beforeupdate Cancel jaydwest Modules & VBA 1 02-25-2006 02:33 PM BeforeUpdate Problem. Steele" wrote: > >> You can't put code like that in the BeforeUpdate event of a control. navigate here

Register Privacy Policy Terms and Rules Help Popular Sections Tech Support Forums Articles Archives Connect With Us Twitter Log-in Register Contact Us Forum software by XenForo™ ©2010-2016 XenForo Ltd. gemmathehuskyView Member Profile Aug 7 2013, 06:16 PM Post#11UtterAccess VIPPosts: 4,267Joined: 5-June 07From: UKi got this a couple of days ago, and eventually realised (after much wasted time) i was trying Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We Compile the database (From the Visual Basic Editor select Debug / Compile {Project Name}). http://www.utteraccess.com/forum/caused-Runtime-error-211-t1936137.html

What line does the error occur on ? Am I not "unbinding" the controls correctly? Sign Up Now! I don't know how exactly this is supposed to be done in code, so I figured I would try the sql statement there.

The error occurred when I changed "On Change" to "On Click". Lightest infusable shield/weapon? ms-access vba access-vba share|improve this question edited Nov 26 '15 at 11:55 w5m 1,34531642 asked Oct 12 '09 at 10:33 SmartestVEGA 2,012124076 add a comment| 2 Answers 2 active oldest votes Member Login Remember Me Forgot your password?

They allow you to create self-contained objects that encapsulate functionality. Close Box Join Tek-Tips Today! mx 0 Message Author Comment by:Megin ID: 382243492012-07-25 I notice you're assigned sql select statements to string variables then trying to populate the form fields with the string variables. see here AU is oK ...

The macro or function set to the Before Update or Validation property for this field is preventing the application from saving the data in the field." I've removed almost everything from asked 7 years ago viewed 3595 times active 1 year ago Blog Stack Overflow Podcast #97 - Where did you get that hat?! You currently have 0 posts. (All code solutions tested in Access 2003/2007, before posting, unless otherwise noted.) missinglinq View Public Profile Find More Posts by missinglinq