To the best of my knowledge, it's only possible to change other fields' values once a field has lost focus (i.e., by tabbing or clicking out, etc.). Even the BeforeChange and Changing events run after a control loses focus.
Jimmy Rishe / Software Developer / Microsoft MVP
Qdabra Software