I'd do this in VBA. Not sure how much you know so i'll start from basics
The form has an event called OnCurrent. This is activated every time the user moves from one record to another record. So if you have 10 records and the user moves from record 1 to record 9 -for example- this event is...