Linking an Access Form to a Word Document with a User Form on Open

C

Chris

I have a command button on my access form that opens up a word document and
fills in data from access at the appropriate bookmarks in the word document.
However, the document has a user form that pops up on open. The data from
access doesn't populate into word until after the user form is filled out &
closed.

I'd like the data from the access form to fill in first, so the fields that
already have data show on the user form. I can't figure out how to get this
to work. I use a very simple code on the command button's click event in
access:

With oApp
.ActiveDocument.Bookmarks("bmproductname").select
.Selection.Text = (CStr([Forms]![Prep Info]![Text32]))
.ActiveDocument.Bookmarks.Add Name:="bmproductname",
Range:=Selection.Range

The user form is set to open in the word document on the document_open
event.

How can I get the data from the access form to show first, or to show right
away on the user form? I'm sure it's rather simple & I'm overthinking....
Any ideas?

Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
How do I clear a form? 0
VBA - exporting serial letters to single documents 0
Linking data in MS Word into Excel 5
Can't save my Office documents (after computer rebuild and reauthorization) 0
Linking a Form to a Word document 0
To protect user's privacy 1
Documents from shared model are created with design mode on 1

Top