Hi Michael, thanks for helping. No Win word is not already running on startup. If I elect to reduce the the access program window before selecting to activate a word template, I can then see the usual template SQL message generated, form there I can say yes and it all works okay. But this only works if i shrink the main access screen. Its like access will not let the winword template sql message come to the fore.
Message box says:
Opening this document will run the following SQL command:
SELECT * FROM 'account table'
Data from your database will be placed in the document. Do you want to continue?
YES NO HELP
As I said this will work fine if I have reduced the Microsoft access screen before selecting to activate the chosen word template. If I don't then I cannot see the above message unless I go into task manager and close win word then the message is seeable.
Works great Machael, thank you for all your help.