Update label each time a new record is displayed

[father]

What event would you use to update a label caption relative to a number field in the same form, so that each time a new record is displayed, it goes through my complicated "if" bva code. I want the letter "th", "st", "rd" to display beside a text box relative to the value displayed.
I suppose I could do this in the query.

 

[RuralGuy]

The forms Current event fires every time there is a different record.

 

[father]

That was the ticket. Thanks again.

 

[RuralGuy]

You're welcome and thanks for posting back with your success.