OK, I can see what you are trying to do.
However whichever way you try to achieve this you are going to have to enter VBA code in the After Update Event of each of the fields that you wish to have the next field updated, or in the "got Focus" event of the the field to be updated.
I cannot find a "Form Event" that will automatically work for any field.