Move To Next Control

[jaydwest]

Now that you can't use sendkeys "{Tab}" anymore. What is the best way to move to the next control on the active form from a Global Module.

Thanks for your help.

 

[Guus2005]

Access 2007?

 

[jaydwest]

Acesss 2003 with Vista Business

 

[Guus2005]

Now that you can't use sendkeys "{Tab}" anymore.

You are mistaken. That statement is still in use.
Form code:

Private Sub Command98_Click()
    TabTimes 2
End Sub

Module code:

Public Sub TabTimes(intX As Integer)
    Dim intI As Integer
    For intI = 1 To intX
        SendKeys "{Tab}"
    Next intI
End Sub

 

[jaydwest]

You know that and maybe I know that but my computer sure doesn't know that. In any case I would like to get rid of all the SendKeys in my Applications, so the question is, is there any other way to tab to the next control on a form without using SendKeys.

 

[Guus2005]

Make sure you don't have an AutoKeys macro which captures the tab.
otherwise, good luck!