Not sure if this is Satire/Sarcasm or not. If so, it's a good one :P.

If not, there can be no future or next control until they finish the mind reading software to know what we want to do next :P.

Yes, although sometimes my mind works in mysterious ways :)

So, couldn't the NextControl be PreviousControl.taborder + 1 ?? Just asking.

I was just going to say that, Gary. It's definitely possible to figure out what the next control in the Tab Order would be. It's not that simple, but you could iterate through them to figure it out. Hmm... video maybe...??? But aside from being trivial would this actually help anyone?

Here's what GPT gives me. I haven't tested it yet, but it's the same algorithm I would have followed:

Dim frm As Form
Dim ctl As Control
Dim nextCtl As Control
Dim i As Integer
Dim found As Boolean

Set frm = Screen.ActiveForm
Set ctl = Screen.ActiveControl

found = False

' Loop through the Controls collection in tab order
For i = 0 To frm.Controls.Count - 1
    If frm.Controls(i).TabIndex = ctl.TabIndex + 1 Then
        Set nextCtl = frm.Controls(i)
        found = True
        Exit For
    End If
Next i

' Handle the case where the next control is not found
If Not found Then
    MsgBox "Next control not found. It might be the last control in the tab order."
Else
    MsgBox "The next control in the tab order is: " & nextCtl.Name
End If

That's not next control that's next tab order :P. My next control was going to be back to the main menu, not pushing tab. Mind reading technology isn't working lol.

In all seriousness, what would an application be of using that where just .setfocus wouldn't accomplish it, other than just because you can? I assume To be able to change a value and continue moving forward into the future fields?

Maybe have Yes/No buttons in the middle of the screen and go down a list of checkboxes marking true or false? Something like this where you would just pick true or false and it would move and mark the next sequential checkbox? Although in my example you might as well just delete the false button, the true button is the only one needed :).

Adam So how do you really feel about TempVars?

There's Tempvars, then recordsets, then way further down, everything else ;).

You could also just SendKeys a TAB. Love me some SendKeys. :)