Maintaining Control Focus

[sabbo64]

Hi,
I'm building a routine which updates a user's insurance details. There is no requirement to create new insurance records for renewed insurance accounts, however, if the user switches insurance provider a new record needs to be created. What I want to do is validate the 'Insurance number' (INo) field so that if the 'Insurer Name' field changes, the user is then prompted to change the INo field. How do I communicate with the user i.e. using msg boxes while maintaining focus on the field to be updated (the INo field). MSGBox idoesn't function in got/lostFocus event with setfocus

[RuralGuy]

Use the AfterUpdate event of the 'Insurer Name' control for your MsgBox and then SetFocus to the (INo) control.

[sabbo64]

Fantastic. Thanks RG, it works a treat

[RuralGuy]

Outstanding! Glad I could help.