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?