AccessMSSQL,
Thank you for posting this as it helped me with a similar but different problem.
My issue was that I had three separate subfoms in a tab control that resided on a parent form. I was unsuccessful in setting the focus on a Textbox.control until I used your solution of setting the...