Merging into Word

[harrisw]

Trying to merge a field on a form to a word document using
.ActiveDocument.Bookmarks("fieldname").Select
.Selection.Text = (CStr(Forms![frmMain]![subfrmMainCompetitor].Form![fieldname]))
The field in question is a combo box and all that is being merged to the word doc is the bound column number and not the field contents.

Any ideas?

 

[charityg]

If the text is in the second column with the first column hidden, use:

.ActiveDocument.Bookmarks("fieldname").Select
.Selection.Text = (CStr(Forms![frmMain]![subfrmMainCompetitor].Form![fieldname].column(1)))

 

[harrisw]

Thanks v much that works great