I have no idea what I am doing wrong.
I have a simple form with a button
When I hit said button I would like access to auto populate multiple word forms but I keep running into an issue when I try with just one word document:
Private Sub Command12_Click()
Dim wApp As Word.Application
Dim wDoc As Word.Document
Set wApp = New Word.Application
Set wDoc = wApp.Documents.Open("C:\Supply_Excellence\_LOGISTI CS CONTINUITY\Documents\Cyclic_Inventory_Memorandum.d oc")
With wDoc
.Bookmarks("Lin1").Range.Text = Nz(Me.Text4, "")
.Bookmarks("Lin2").Range.Text = Nz(Me.Text6, "")
.SaveAs2 ("C:\Supply_Excellence\_LOGISTICS CONTINUITY\Inventories\Cyclic_Memo_Unsigned_" & Format(Now(), "yyyymmdd") & ".doc")
.Bookmarks("Lin1").Range.Delete wdCharacter, Len(Nz(Me.Text4, ""))
.Bookmarks("Lin2").Range.Delete wdCharacter, Len(Nz(Me.Text6, ""))
End With
DoCmd.Requery
DoCmd.OpenReport "ReportCYCLINS", acViewPreview
wDoc.Close
wApp.Quit
End Sub
however access is not filling in the bookmarks with the data from the forms text boxes. These are unbounded text boxes and not related to any table.