Access to Word - ID/Name

[Sharon]

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?

 

[Doug Robbins - Word MVP]

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.

--
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