From vba in Microsoft Access, how can I open a form saved in a word .docm document and set a textbox on the form to a value?
So far I have:
Dim objwrd As New Word.Application
Dim doc As Word.Document
Set objwrd = CreateObject("Word.Application")
objwrd.Visible = True
Set doc = objwrd.Documents.Open(FileName:="C:\Users\db1\Documents\Test.docm", Visible:=True)
I know if I'm running code contained in the Word document I can do something like this
Dim frm As New UserForm1
But this code is automation code running in Microsoft Access and I don't see a forms collection in the Document object.