VBA switching between application

[Lauro]

From Acces the user create a Word document, then clicking on a menu he
should go back to an Access Form to get some record's value.

How I can set the focus on Access via VBA code?

thanks, Lauro


P.s.:
AppActivate "task bar name of Access"
return a runt-time 5 error

 

[Cindy Meister]

You know you'd need to have the code IN WORD in order to do this. So you
first need to consider how that's to be done. For instance, would users be
working in a particular kind of document, only, when they need to do this?

How is this document being created or opened?

Why would they need to switch back to Access? Wouldn't it be possible for
VBA to use DAO or ADO to pull this information out of Access into Word,
without needing to bother the user with switching back and forth? Or couldn't
it perhaps be sent to the document when creating/opening?

-- cindy