SetFocus Problem

[DanG]

This should be pretty easy..
I have a form called dataentry with a field called "Advisor#". Then I have a subform to Dataentry called "LT2DataEntrySubform1" and a field on that form called "QRT".
I tried to set the focus on QRT on the main forms "on current" event. But both Advisor# and QRT are highlighted at the same time and I can not just start typing I have to click on a field to un-highlight and begin typing which defeats the purpose of setfocus. There is no other macro/VBA in this form to interfere with my code.
Here is the code:

Private Sub Form_Current()
Me.LT2DataEntrySubform1.Form!QRt.SetFocus
End Sub

I also tried to call the procedure from the main form and got same problem.
Don't go too far over my head I am still in the VBA Kiddy-Pool

Thank you,

 

[bradcccs]

First tip: Avoid using special characters (# $ % ^ &) in form / report / field / dog names.

Use only A-Z, a-z, 0-9, and Underscore (_).
(Whilst I am at it, don't start names with a number either).

All in the name of good practice.