Change border color of textboxes when they have focus

[theDBguy]

Hi, Thank you very much for the speedy reply.
I have tried various methods/adaptations of this code to include my subform but been unsuccessful each time. I Think the issue is, I have not referenced my subform on my main form.
So the border colour changes in my main form as expected but when I tab to my subform I get the error “2450 - Cannot find referenced subform” OR I can tab to the subform but the focus (border colour change) remains on the last control in my main form.

Just curious, have you considered using this one?

Microsoft Access tips: Highlight required fields or active control

Automatically flag the fields where an entry is required when a Microsoft Access form opens, and automatically highlight (in yellow) the controls as they get focus.

allenbrowne.com