Form Event Procedures

[TasCat09]

Hello
I am trying to update the caption of a number of buttons on a form. I can update the captions with the use of another button so I know the VBA code is correct.
However, I cannot find an event that I can attach the code to in order to automatically update the buttons.
The names of the buttons come from text boxes which in turn get their values from control source relationships from subform fields.
Can anybody help me?

 

[RuralGuy]

Have you looked into the OnCurrent Event?

 

[TasCat09]

Yep, doesn't seem to fire when the focus changes from one record to another on a subform which is what I need.

 

[RuralGuy]

The Current Event of the SubForm will fire then.