Tab order: next control after Calendar control

[BPBP]

I have the tab order set to go to the next textbox after using a calendar control. However after the clicking a calendar date, the focus doesnt go to the next control, it goes back to the first control on the form.
I have tried setfocus to the next control in the after update event but it doesnt work(focus still goes back to first control of the form). Any suggestions?

 

[Poppa Smurf]

Try DoCmd.GotoControl "name of the next text box"

 

[BPBP]

Tried, that doesnt work properly. Same result as using setfocus command.

Tried this command in After-update event- focus goes to the 1st control of the form and the date selected is not saved.

Tried this command in the on-exit event - The focus goes to the next control as required however the Date selected in the calendar is not saved...

btw, i have the visibility of the calendar set when the control is entered or exit. Private Sub Status_Date_Enter()
Calendar4.Visible = True
End Sub
Private Sub Status_Date_Exit(Cancel As Integer)
Calendar4.Visible = False
End Sub