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 ...

[rpeare]

If your data is always going to be less than 24 hours make your field a date/time field and put it in the format you want (short time for instance). That will prevent anything of more than 24 hours being entered.