Sign up now! Private Sub StateBox_AfterUpdate() Me.DVPCBox.Requery If (Me.DVPCBox.ListCount >= 1) Then Me.DVPCBox.SetFocus 'Me.DVPCBox.ListIndex = 0 //<-Error here Me.DVPCBox = Me.DVPCBox.ItemData(0) End If End Sub I also changed ListCount >= 1 because I assumed Find More Posts by boblarson
Teaching is not filling a bucket but lighting a fire. The before update event will run for unbound textboxes. So I created a very simple string as an illustration. I couldn't recreate the locking of the list box.
Have you done this approach before where you assign a sql statement (in form of a string variable) to a form field? The form in the Sratch.mdb wasn't bound to the recordset, but once I set it, I was able to put 2 text boxes on the form and observe that the recordset share|improve this answer answered Oct 12 '09 at 11:43 Tony Toews 7,05511324 add a comment| up vote 1 down vote I know this is an old thread, and has already been I suspect where you're hitting problems is that after you cancel the update (or technichally slightly before even) you are attempting to change the value again.
boblarson View Public Profile Visit boblarson's homepage! There are better ones in this thread that don't come along with the same problems. Same results Windows XP & Vista. Even still, it does seem odd that you would get THAT error occurring in the AU event of cmbVNumber ...!
When you decide which it is then you are more than half way to resolving your problem. Join them; it only takes a minute: Sign up MS Access runtime error 2115 up vote 1 down vote favorite In Ms Access, I have two unbound combo-boxes: StateBox and DVPCBox. Do I need to set some property of > the form or control to make it unbound maybe? view publisher site Post your question and get tips & solutions from a community of 418,948 IT Pros & Developers.
Compact the database (Tools / Database Utilities / Compact and Repair Database...). Do I need to set some property of the form or control to make it unbound maybe? All rights reserved. I initially Read BeforeUpdate here cmbVNumber_AfterUpdate() ...
I would contend this is one such instance. changing to .value instead of .text worked for me in Access 2010. Why aren't there submission fees for submitting papers to conferences? It takes just 2 minutes to sign up (and it's free!).
Site Message (Message will auto close in 2 seconds)Welcome to UtterAccess! http://divxpl.net/microsoft-access/microsoft-access-error-3033.html Join & Write a Comment Already a member? That may be the issue.« Next Oldest· Access Forms· Next Newest »Display Mode: Standard · Switch to: · Switch to: OutlineTrack this topic ·Email this topic · Print this topic · Can't seem to get any ideas here.
Jul 10 '09 #14 reply 100+ P: 675 OldBirdman I'm posting the version of this program as last described (Post #11). 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 Setting the cancel to true will then prevent the cursor exiting the control. check over here About Us PC Review is a computing review website with helpful tech support forums staffed by PC experts.
Can you elaborate some more? It's quick & easy. Adding more controls or code gets me the Run-time error '2115'.
Join our community for more solutions or to ask questions. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. You are trying to save it again inside the save routine. May 25 '10 #7 reply P: 6 Rolrox My experience was that setting "Cancel = True" doesn't reset the field to its earlier state; so instead, with the OnCurrent event I'm
Wednesday, September 24, 2008 5:39 PM Reply | Quote 1 Sign in to vote Had the same problem. I was using a drop down box to trigger a lookup to populate Learning resources Microsoft Virtual Academy Channel 9 MSDN Magazine Community Forums Blogs Codeplex Support Self support Programs BizSpark (for startups) Microsoft Imagine (for students) United States (English) Newsletter Privacy & cookies The single lineMe.txtLine1 = " "will accomplish what the OP wants to do. this content If you change a bound form control (ie control.text for example) the form control will change but then because it is bound to the underlying database field the field cannot be
Therefore, the bound column is Key. How can Data be property of Starfleet? I don't use Access Validation field in this program. Personally I will wait until I'm forced to before using it.