Access to Word - ID/Name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sharon - 14 Jul 2006 16:12 GMT

I am using an access database to populate fields in a Word document. In the
query in Access I have used a combo box for SupplierID/SupplierName. When
the query is run in Access it shows the SupplierName, which is what it is
supposed to do, but when I mailmerge into Word it shows the SupplierID, which
is just a number and not the name as intended. I have read the other entries
regarding switches, mailmerge from Access to Word, but I can't find anything
that addresses this issue. Can anyone help?

Signature

Reply to this Message

Doug Robbins - Word MVP - 14 Jul 2006 18:10 GMT

While I know that you can use a combo box in a query, I have never had, nor
can I think of when I would want to do that.

I do not think that it would be appropriate to use such a query as a
datasource for mail merge.

Tell us how it is supposed to be used.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am using an access database to populate fields in a Word document. In
>the
[quoted text clipped - 7 lines]
> anything
> that addresses this issue. Can anyone help?

Reply to this Message

Rate this thread: