Hi!
Just store old value of the text box in some variable or object property. In the Valid event compare it with existing value to see if it changed. If changed - do code required for all otehr calculations.
>I have a form with the following methods (among others):
> Part ID - Combo Box - Row Source is a cursor - control source is Part ID
> Quantity - Spinner
> Charges - Text box
>
>When I selec t a new Part ID, the Charges should become the Price of the part times the Quantity. The Charges needs to update when a new part is selected before exiting the field. Charges = Price for the Part ID times the Quantity. The user needs to
>
>Methods:
> Click - The record pointer has not moved and the Value property had not yet updated. The new base price of the part cannot be acertained.
> InteractiveChange - The record pointer has not yet moced so the base price is not yet known.
> Valid - The record pointer has moved but, it fires even if the user has not sele cted a new Part ID.
>
>Does anyone know of a method that fires after the record pointer has moved, the control source has been updated and before the focus has moved?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.