Sorry to be so long in reply, this project got temporarily put aside for other workload. Are you talking about the Document_Open of Microsoft Word or on the Microsoft Access side. My explanation was bad, it's not the opening as a doc that is a problem, it's that when Access opens the Word document it opens the template as if you were opening from the file/open menu in Word instead of opening as file/new. This causes the automation in the form to not activate. I'm not finding on the Access side how to accomplish this and do not know visual basic on the Word side. I am barely making my way through learning Access code by trial and error, so I'm needing help on the Access side if possible, cause I am very lost in Word. Also, I've got merge fields in some of the Word forms I'm using that feed from the Access side, however, is there a way to pass that field data into the Word form when you open it, thereby doing away with the merge and still accomplishing the data portion. Thank you, Cathy "Dian Chapman" <dian@mousetrax To: <mso@xxxxxxxxxxxxx> .com> Sent by: cc: mso-bounce@free lists.org Subject: [mso] Re: Open Access OLE Word Doc as Template 12/14/2003 04:47 AM ..... Please respond to mso Templates are SUPPOSED to open as docs. Just add the automation into the Document_New event to get it to fire properly. It's probably in the Document_Open or Auto_Open/Exec events. It should be in the Document_New event. Dian D. Chapman Technical Consultant, Microsoft MVP & Instructor Free Tutorials: www.mousetrax.com/techtrax Free Word Tips & Tricks eBook: www.mousetrax.com/books.html Learn VBA the easy way, thru video! www.mousetrax.com/techcourses.html -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Cathy.Evans@xxxxxxxxx Sent: Sunday, December 14, 2003 12:35 AM To: mso@xxxxxxxxxxxxx Subject: [mso] Open Access OLE Word Doc as Template Hello, I have an Access 97 database with linked .dot forms. Clicking the link opens them in Word as documents, not templates, causing loss of the automation built into the forms. Have tried embedding as OLE instead of link but it still opens .dot as .doc. Have been searching the net for code solutions but no answers. Can anyone help? Thank you! :) ----------------------------------------------------------------------------------------------------- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, review, retransmission, dissemination, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you received this in error, please contact the sender and delete the material from any computer. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of the company. ------------------------------------------------------------------------------------------------------- ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************