Passing the ComboBox text value in Access to a Bookmarked Location in Word

[drmsktchr]

So, I am an extreme newbie when it comes to using VB in Access. But, I have created a Form to help automate a Report in Word. I have been successful in getting all the the text boxes to populate the appropriate bookmarks within the Word Report. The issue I am having currently, I have a combo box holding names (first and last) that is being populated by a query from a table. When I submit the form, it populates the associated bookmark in Word as an Integer value, but what I need is it to be passed as the actual string. I have searched threads for a couple of days on some assistance and to no avail. So I am here hoping for help. Can anyone help direct me or guide me.



The code I am using is the following:

'Move to each bookmark and insert the text from the form to Word document
.ActiveDocument.Bookmarks("preparedBy").Select
.Selection.Text = (CStr(Forms!WebBasedIFV!comboPreparedBy))
'reapply the bookmark name to the selection throughout rest of Word Document
.ActiveDocument.Bookmarks.Add Name:="preparedBy", Range:=Selection.Range

So what will I need to do in order to have the form output the actual String of the name?

[pbaldy]

.Selection.Text = (CStr(Forms!WebBasedIFV!comboPreparedBy.Column(x)) )

Where x is the number of the desired column of the combo's row source (zero based).

[drmsktchr]

.Selection.Text = (CStr(Forms!WebBasedIFV!comboPreparedBy.Column(x)) )

Where x is the number of the desired column of the combo's row source (zero based).

Hi Paul, thank you so much for your help, that seems to have solved the problem. Now my next task is to figure out how to return values from a list box if there are multiple selections.

Thank you again Paul.

[pbaldy]

No problem. This isn't doing exactly what you want, but the loop is the typical way to get selected items from a multiselect listbox.

http://www.baldyweb.com/multiselect.htm

[drmsktchr]

Thank you Paul, you have been a tremendous help.

[pbaldy]

No problem, and welcome to the site by the way!