>OK, so the follow-up question is: When you “Do Form” from an event procedure(i.e. a command button), how do you get the program to pick-up where it left off when the called program ends?

Alan,

Make the form you are doing modal. Modal forms stop execution until they are dispatched, non-modal forms do not, they let code continue and don't stop the code while they do their thing.