Ok.. I think i have pounded my head on the desk enough .
Here is the issue. I have a word document that I am setting up as a template. Simple merge of data but however it's always only 1 record so I am thinking a mailmerge is not really necessary since it only has one record / form infomration to put into the document.
So I setup a template in word 2007 and called it prop2.dotx. In this document I put a bookmark named : "Estimate". I will have other bookmarks but figured I'd get one to work first
on the main form I have a button that is going to populate these bookmarks. Access launches word and then i get a error: Obect variable or with block not set. HELP .
Here is the code:
Dim objWord As Word.Application
Dim objDoc As Word.Document
Dim dbPath As String
dbPath = CurrentProject.Path & "\"
Set objWord = CreateObject("Word.Application")
.Visible = True
Set objWordDoc = .Documents.Open(dbPath & "prop2.dotx")
.Bookmarks("Estimate").Range.Text = Me.EstimateID.Value