Form values getting auto updated at back end.

[pratim09]

I have a sub form with multiple records. i double click a record and open it to modify .I have a field called hours in the modification form where there is a check if hrs is > 24 throw a message or else do the moidfication with update statement.Problem is if I give hrs more than 24 and update its giving me the msg but behind in the subform I can see that the record value of hrs is already updated with the increased value. I know closing the form creates some problem like this and so I have disabled the close button in the form and my form has only update button and a close button(which undo the form and closes).



Plz suggest how I stop this sort of auto updating ...

[ssanfu]

There are many things that can cause a form to save changes.
Just moving from one record to a different record will cause the data to be saved.

What code do you have in what events?

I would think you would have code in the Form Before Update event to cancel the save if the hours is > 24.

[boblarson]

You need to use the BEFORE UPDATE event of the form where the value is being entered to check (a DSUM could work) if the resulting value will be over 24 and, if so, issue a

CANCEL = TRUE

in that before update event. Then you will likely need to undo the record on the form.

Me.Undo