before update cancel not working

J

Jim Burke in Novi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top