Word Word merge from Access 2007 to Word 2007 brings over PK value and not text value.

Jul 13, 2011
Reaction score

Can someone help me please. I have a word merge running from an Access 2007 form to word (Mr Kallals' great code). The problem is that I set up certain underlying tables with numeric primary keys and then their second field contained the text I wanted to show on the form.

e.g. Column 1 Primary key
Column 2 Location

So PK 11 shows as 'Anywhere UK' on subsequent forms and queries. The problem is that my merge with the VBA module mentioned above and the word merge operation in Access' export facility only show '11' instead of ' Anywhere UK'.

I'm really stuck and very weak with vba. But surely this is something that might be fixed from within Word as much as Access

Can someone help.


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