BeforeUpdate Cancel not always working...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a bound form with several bound controls (along with some unbound
controls). I created a BeforeUpdate event proc for one of the bound fields
and in some cases I set Cancel = True to cancel the change to the field. This
isn't working on this particular form - I tested it in Debug mode to make
sure the Cancel value is being set to True. Sometimes Cancel has worked for
me in the past with other forms, but sometimes it doesn't work! There's gotta
be an explanation. Any ideas?
 
It *has* to work, but maybe you have some corruption. Create a new, empty
mdb with Name AutoCorrect turned OFF and Compact on Close turned ON and close
it. Then open it again and import everything from the old mdb into the new
one and close the new one. Now open the new one and try it. Cancel = True
in a control will hold the focus in that control unless you are closing the
form or I believe moving to another record. Why do you believe it is not
working?
 
Back
Top