01-30-2008, 01:32 PM #8 RuralGuy AWF VIP Join Date: Jul 2005 Location: @ 8300' in the Colorado Rockies Posts: What line does the error occur on ?

The reason why I ask is because I've never seen this approach before. 0 LVL 75 Overall: Level 75 MS Access 75 Message Active today Expert Comment by:DatabaseMX (Joe Anderson Thanks for your help, I have now got it working. Thread Tools Rate Thread Display Modes 01-30-2008, 05:47 AM #1 robben Registered User Join Date: Jan 2008 Posts: 52 Thanks: 0 Thanked 0 Times in 0 Posts BeforeUpdate Error this page This is done because the data may be entered in a couple of different formats but is distilled so that it is saved and later processed in only one.

Jeanette Cunningham, Jan 1, 2010 #5 Advertisements Show Ignored Content Want to reply to this thread or ask your own question? Red Flag This Post Please let us know here why this post is inappropriate. I'm still confused as to why you'd want to set the textbox to an empty string at this time. [Forms]![MyForm1].[txtPhoneNumber1] = " "works because you're using the Value property (it's the

Privacy statement Help us improve MSDN.

RE: runtime error 2115 jebry (Programmer) 2 Jun 05 14:36 Hi!What line is giving you the error?A couple of things to note, instead of the .SetFocus and .Text use the .Value:Private It's displaying data from previous versions of my > project. Yes, my password is: Forgot your password? Why is this? > > I also don't understand why these controls seem to be acting as though > they are bound, why are they hitting a before update event if

Steele Aug 16, 2006 Formula to calculate time between start time and End time Guest, Oct 19, 2006, in forum: Microsoft Access Forms Replies: 5 Views: 1,319 Douglas J. Do you have a repeatable example of this strange behaviour? Browse other questions tagged ms-access vba access-vba or ask your own question. Get More Info Guess I would have to be there :-) mx 0 Write Comment First Name Please enter a first name Last Name Please enter a last name Email We will never share

What I'm trying to do is write to the textbox from the listbox click event.Below is the code where the error occurred. skea General 6 03-31-2005 04:18 AM Cancel BeforeUpdate Event wjoc1 Modules & VBA 5 07-23-2004 03:24 AM All times are GMT -8. I am stumped, once again. 0 Question by:Megin Facebook Twitter LinkedIn Google LVL 75 Active today Best Solution byDatabaseMX (Joe Anderson - Access MVP) See if this changes the problem: For The content you requested has been removed.

boblarson View Public Profile Visit boblarson's homepage! You currently have 0 posts. This doesn't make much sense logically. Duh...sheesh - can't I read...I guess not....

Mar 9 '10 #1 Post Reply Share this Question 12 Replies Expert 5K+ P: 8,394 ADezii Setting Cancel = True will not allow the Form to be updated, and I don't states and DVPCBox contains Employee Names from a query based on the value of StateBox. try just this: Me.txtName= StrSql1 Me.txtDateOut= StrSql2 Me.txtInitials= StrSql3 Me.txtNotes= StrSql4 Are these all Unbound fields ? 0 LVL 10 Overall: Level