From what I gather I think the OP wants to fire the code once per record. So if he goes to record 1, it fires, he moves to record 2, it fires, he moves back to record 1, it should not fire. Is this what you're trying to do pusher?
What view is your form in? Datasheet, Single or Continuous?