Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / March 2008

Tip: Looking for answers? Try searching our database.

before update cancel not working

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jim Burke in Novi - 31 Mar 2008 15:55 GMT
I have a form that is bound to a table. On that form I have text fields for
various fields from the table. In some cases if the user tries to update a
field with an invalid value, I want to cancel their update. I call a function
in the field's Before update event proc that checks to see if the value is
valid, and set Cancel = True when that function returns a false value. I know
that Cancel is being set to true, checked it out in Debug mode, yet the field
remains updated afterward. Any ideas why? Any help is appreciated.

Jim B
Alex Dybenko - 31 Mar 2008 17:43 GMT
Hi,
well, never saw this. make a simple form and try it there, perhaps something
wrong with your code.
you can also try to use form's beforeupdate event

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

>I have a form that is bound to a table. On that form I have text fields for
> various fields from the table. In some cases if the user tries to update a
[quoted text clipped - 8 lines]
>
> Jim B
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.