Go to a text Box

[Hemish]

Hi i'm trying in MS access go to a text box after exiting a certain text box on a form.

I thought this would work : me.txtTrack.setfocus
It does not work and goes another the next text box which is in the tab order. I do not want to change the tab order.

Please can you help

Thanks

 

[boblarson]

Which event did you put the code on?

 

[Hemish]

i put the code in on "ON Exit", As soon as you exit the text box the code will run in the background then i want the focus to go back to that same text box

 

[ghudson]

The focus has to be set to another text box in your code before it can be set back the txtTrack text box. The focus is not leaving the txtTrack text box with the way you are doing it now. Also, I would use the OnLostFocus event instead.