Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Error Msg executing cancel in textbox
I found a workaround for this problem, should anyone else come across it. From reading other posts on the internet, this seems to be an issue when viewing the form in Datasheet view. Instead of using Cancel = true, use DoCmd.cancelevent. This works for me. Thanks for your help, Skip. aslrunner- aslrunner
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Error Msg executing cancel in textbox
Interesting observation SkipVought; however, I find that is how Microsoft uses it per their help files: Private Sub ProductName_BeforeUpdate(Cancel As Integer) If(Not IsNull(DLookup("[ProductName]", _ "Products", "[ProductName] ='" _ & Me!ProductName & "'"))) Then...- aslrunner
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Error Msg executing cancel in textbox
I have a textbox on a form with the following code for preventing data entry that doesn't meet certain criteria. However, whenever it exits this procedure I get the Error 3270 "Property not found" error. It only shows up if the Cancel = True command is executed. If it's not there the if...- aslrunner
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
