I have VBA that uses Application.FollowHyperLink to open a Word do***ent.
My
intention is that after the users have taken note of its contents and
closed
it, my code opens another Access database. Problem is, B doesn't wait for
A
to complete. The Word do***ent opens and is on top for a couple seconds,
but
then the database opens and pushes the Word do***ent into the background.
What can I do to, in effect, make my Word do***ent acDialog so nothing
else
happens until the user has closed it?