I'm not really very familiar with Access95 (mostly 97), but can't you set the rest of the code to occur on the event of the form update, or a similar event to indicate the response you are looking for?