switching screens

[Tom]

When using windows, I can hold alt and tab to change my
screen. Why can't I get my macro to do the same thing. I
have the send key holding alt and tab, but nothing
happens. Sometimes I get a message about spell check or
something along those lines. How do I escape this
problem???
..

 

[Van T. Dinh]

My guess is that you SendKeys send the keys to Access application rather
than the Windows OS.

Check Access VB Help and try the AppActivate Method instead.