I know I should be able to figure this out on my own, but this newbie's brain is too full at the moment so I'm asking for assistance.

Here's what I need:

I have an Access form with two comboboxes: One for selecting a client ID and the other for selecting among the titles of various Microsoft Word templates that contain fields corresponding to the fields in the client table in Access. (The former list is actually pulled from the related client table in the Access database; the latter list I just typed in myself, with the titles matching the titles of the Word templates that I keep in a separate folder.) There is also a GO button.

What I would like to happen when the GO button is clicked, it that the selected client's information gets merged with the selected Word template all in one step. (In other words, I don't want the user to have to choose the correct client record as a second step once they arrive at the Word template -- I want it to happen all as one step, ready for printing.)

I know in theory how this should work, but I don't know enough VBA vocabulary yet to write the code myself. Hoping someone out there can help me with this!

Kimber

I'll give it a shot.

From what I recall, Word will only merge with an Access table, not with query results. So I would create a merge table with the fields you want, then do this on the GO button:

Run a delete query on the merge table
Run an Append query using the ClientID as a parameter.
   Create an append query with the appropriate fields,
   then in the ClientID column add this,
     [Forms]![frmMyForm].[cboClientID] or whatever the name of the form and control is.
Then launch Word.

Do you need more help?



mmcdonal

Look it up at: http://wrox.books24x7.com

Thanks -- I'll give it a try.

Kimber

Worked like a charm! Thanks!