P
Paolo
Hi,
I am validating a series of textboxes for null on a bound form using
the before update event. I also have a button on the header part of
the form that runs DoCmd.RunCommand acCmdFind on its click event. If I
null one of the textboxes and click the button, I get a msgbox from my
before update event indicating that one of the textboxes is null. This
works fine as I have coded for it. But then, if I hit ok, I get a code
error. The code error is either 3709, 2169, 3021 randomly. Why? Note
that I do set cancel = true in my before event. Would that have
something to do with it? Because if I comment out the cancel=true,
everything seems to work. But then I have no validation.
Help!
Thanks
Paolo
I don't check this e-mail address, only [email protected],
eliminate the NOSPAM
I am validating a series of textboxes for null on a bound form using
the before update event. I also have a button on the header part of
the form that runs DoCmd.RunCommand acCmdFind on its click event. If I
null one of the textboxes and click the button, I get a msgbox from my
before update event indicating that one of the textboxes is null. This
works fine as I have coded for it. But then, if I hit ok, I get a code
error. The code error is either 3709, 2169, 3021 randomly. Why? Note
that I do set cancel = true in my before event. Would that have
something to do with it? Because if I comment out the cancel=true,
everything seems to work. But then I have no validation.
Help!
Thanks
Paolo
I don't check this e-mail address, only [email protected],
eliminate the NOSPAM