Sendkeys not compiling

[twgonder]

I've got a form that may try to setfocus to a control that's not enabled.


So, I'm working on a sub to pass focus to the next sequential tabbed control.

I've tried to samples from outside threads,
the first one doesn't work and the second suggested solution won't compile.

I can't figure out why the compiler doesn't like the "{" for the TAB I want to send.


I've even tried copying the {TAB} from the MS help page for sendkeys.

I'm using a Latin keyboard, and the Region is set to Colombia.
I've tried the "[" and "(" to no avail.

I would like to avoid SendKeys, but the first suggestion that's commented out throws this RTE:
Application-defined or object-defined error

Post note: Okay, dummy me, needs to be in quotes.
Still, I would like to do it without SendKeys (love how it tabs in the VBA Editor while stepping through the code)

[twgonder]

Also, cool if there is a way to just go to the first tab, and if it's not active go to the first that is active.
Access may do the second half of this automatically.
When I mention tab, I don't mean the Tab Control, I mean the Tab Order of objects on the form.

[Minty]

This thread might help:
https://www.access-programmers.co.uk.../#post-1916671

[twgonder]

@ Minty, post# 3 Thanks, didn't see that in any of my Google searches, but a quick read tells me a second pass at understanding it, with some modifications, will do the trick.