Mail Merge - Access 2010 - drop down field

[lynnmc26]

My form has a drop down field in Access, however, when utilizing the mail merge function only the ID number comes up in that field instead of the text.

How can I fix this?

Thanks

Lynn

[alansidman]

You will need to build a query for your mail merge and bring the lookup table into the query. You are getting an ID number because that is what is stored in the table you are getting your results from. You will need to grab the description from the lookup table that corresponds to the the ID number.

[lynnmc26]

Ok - thanks I will give it a try....have a great night.