Transfering Form data onto word document template

[stu_C]

Hi all
I have an access form that once filled out you click a button and transfers everything onto a word template, issue I am having is although the word document is saved as a word template (.dotx) when I use the access form to fill it out it opens the actual template and puts all the data on the actual word template instead of a new document like it would do if you clicked on the word file normally, is there a round this?

Problem we have if more than one person clicks to create a document they can only do read only

Dim oWd  As Object'Word.Application

    Dim oDoc As Object'Word.Document

    Dim bm   As Object 'Word.Bookmark

    'Set oWd = NewWord.Application
    Set oWd =CreateObject("Word.Application")
    Set oDoc =oWd.Documents.Open("C:\WORDTEMPLATE.dotx")



    Set bm =oDoc.Bookmarks("NAMEID")

    bm.Range.Text =UCase(NAMEID)

    oWd.Visible = True



    Set bm =oDoc.Bookmarks("ADDRESSID")


    bm.Range.Text =UCase(ADDRESSID)


    oWd.Visible = True

[June7]

First, I have to ask why an Access report will not meet this output requirement. Is there really that much 'boiler plate' and special formatting in the Word document?

Review https://stackoverflow.com/questions/...ng-access-data

Instead of Documents.Open use Documents.Add