Dave Unger wrote:
Hello,

My problem is illustrated here with a form that contains a textbox and
a spin button. The spin button updates the variable Mnth, sub
FormRefresh updates the form with new values, and returns the focus to
the text box.. However, focus isn't always returned to the text box,
in fact it flip-flops between staying on the spin button and and
returning to the text box.. If I insert a breakpoint or a message box
anywhere in the loop, it works the way I expect it too, so I suspect
this is a timing issue. However, inserting Waits or other delay
tactics doesn't seem to fix it. Appreciate any suggestions, thanks.
Regards,

DaveU

Private Sub spnDate_Change()
Mnth = spnDate.Value
Call FormRefresh
End Sub

Sub FormRefresh()
'
' code here that updates myForm according to Mnth value
'
myForm.txtEntry.SetFocus

End Sub



Try this it works for me. Phillip London UK

Private Sub Spndate_Change()
FormRefresh
Me.Spndate.SetFocus
Me.txtentry.SetFocus
End Sub