SetFocus will not work

[thart21]

I have a mainform with a subform. I have a field "DateCompleted" that, when it's clicked a pop calendar opens, the user clicks the date and it drops into the "DateCompleted" field. I want focus to be set to the adjoining field after this but for some reason it will not work.

I have tried these solutions in the AfterUpdate event of the "DateCompleted" field.

Attempt #1 Me.Hours.SetFocus
Attempt #2 DoCmd.GoToControl "Hours"

Thanks!

Toni

 

[Rob.Mills]

In the popup calendar have it set the focus instead of the event in the date field.

So after it sets the date the next line should be setfocus