Hi,
I would like to be able to compare a control's new value with its old value,
whenever it is changed by a user.
The control holds a numeric value, qty_Sold, when this value changes I need
to check its validity and apply appropriate actions.
I have tried to do this using the control's 'On Change' event, and the
properties '.Value' and '.Text' to return the control's old and new values.
Unfortunately this event triggers on each character entered.
i.e.
to change an old value of 1 to a new value 234 would trigger the code
behind the event three times:
changing the “1” to a “2” - code triggered;
user must now re-enter control, position cursor to right of the “2” and
enter “3” - this triggers code;
user must now re-enter control, position cursor to right of the “3” and
enter “4” - this triggers code, for the final (and only required) time.
Clearly this isn't acceptable to the user, so how do I achieve the required
comparison only when the user has completed their change?
I don't know if this effects anything, but the control is in a datasheet sub-
form.
Many thanks,
Simon
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200803/1