How to find sequence of focus

[BigJimSlade]

Hey, Big Jim here,

Does anyone know if Access keeps track of where focus was set previously? Say I clicked from combo box to list box to text box. Is there anyway for me to view the user's selected sequence?

Thanks in advance, Big Jim

 

[Atomic Shrimp]

Just an idea - you could keep a track using the OnLostFocus event of each control. You'd have to have some way of storing the data - perhaps an array.

HTH

Mike

 

[Richie]

This may help
Screen.PreviousControl.SetFocus

 

[BigJimSlade]

Big Jim just has to let you know that you guys are great. Thanks for all of your help. Both ideas were excellent and worked perfectly.