form exit problem

[lavi111]

i have a form that has a button that add a new record. int the button im checking if the amount i order is ssmaller than my amount.
if i press the button it works fine but if i have data on the text boxes and i close the form with the close button the data on those text box is save in a new record and it is not checked.


why it add's a record when im exiting the form?
how to solve it?

[pbaldy]

A form bound to a table will automatically try to save. Do your validation in the before update event:

http://www.baldyweb.com/BeforeUpdate.htm

[Missinglinq]

...Do your validation in the before update event...

Note that Paul means the Form_BeforeUpdate event, not the BeforeUpdate event for the Amount Control.

Linq ;0)>

[lavi111]

thank but i managed to solve it with me.Undo first

[pbaldy]

Note that Paul means the Form_BeforeUpdate event, not the BeforeUpdate event for the Amount Control.

Linq ;0)>

That is mentioned in the link.

[Missinglinq]

You know that, Paul, and I know that, but OPs tend to not carefully read all the information when we give them a nice link like yours!

I'm trying to figure out how (and where) the problem, as stated, was solved with 'me.Undo first!' Bet it wasn't in the Form_BeforeUpdate event!

Linq ;0)>