empty record after BeforeUpdate validation

[eugenio.pombi]

Hi to everybody,

I successfully put a validation rule that controls that the value
inserted in a field is valid.
On the BeforeUpdate event I trigger the validation code and if anything
goes wrong I give cancel = true.

The result of this is that the user is stuck inside the field until he
puts a valid value or leaves a blank field. And this can be ok.

The validated field is put as the first field of the form. It can
happen that after the error message the user decides to leave the field
blank and don't continue insert process. The problem is that access
adds anyway a new record that is completely blank.

I tried to put cancel=true on form BeforeUpdate if all fields are
empty, but this makes the user stuck in the present empty record. I
tried also to fire Me.undo on form AfterUpdate but it doesn'work, an
empty record remains inside the table.

Could you please help me.

 

[Arvin Meyer [MVP]]

Add:

Me.Undo

to your code. That is the programatical way of hitting the escape key. You
will still use an autonumber, but you won't leave a blank record.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access