mappoint looses forms focus

[Gil]

hello,
im automating mappoint through access to get mileage between two
address fields. when ever i call the function it makes mappoint the
focus, and i have to reclick the access screen to regain access forms
focus. how can i get access focus via vba and without having to click
the form?

i tried using docmd.selectobject acform, "myform" and me.setfocus . it
looks like it works by highlighting a text box however the mappoint is
still under focus and doesnt set the focus back to the form. if i hit
alt+f4 it will ask me if i want to close mappoint. thats how you can
tell for sure mappoint is still under focus.
any ideas?
if the mappoint app was hidden im sure it would solve this problem but
i do not want the mappoint app hidden. i want it open , but just
minimized, so the user can have the option to restore mappoint and play
around with it and than minimize it again.

any ideas?
thanks

[David Lloyd]

I am not sure what version of Access you are using, or the specifics of your
code, however, you may want to look at the AppActivate VBA function. In
Access 2003 for example, each form is given its own window. So you could
activate the actual form directly. For example:

AppActivate "MyForm", False

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"Gil" <gi*******@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
hello,
im automating mappoint through access to get mileage between two
address fields. when ever i call the function it makes mappoint the
focus, and i have to reclick the access screen to regain access forms
focus. how can i get access focus via vba and without having to click
the form?

i tried using docmd.selectobject acform, "myform" and me.setfocus . it
looks like it works by highlighting a text box however the mappoint is
still under focus and doesnt set the focus back to the form. if i hit
alt+f4 it will ask me if i want to close mappoint. thats how you can
tell for sure mappoint is still under focus.
any ideas?
if the mappoint app was hidden im sure it would solve this problem but
i do not want the mappoint app hidden. i want it open , but just
minimized, so the user can have the option to restore mappoint and play
around with it and than minimize it again.

any ideas?
thanks