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

[Kellyzeroes]

Hello,

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.

Thanks