Help with lookup columns when merging to Word.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For those fields where I use a combobox to pick a particular value (for
example, a province/state), I have trouble when I use the database as the
source for a merge in Microsoft Word. The original query looks okay but
after the merge, instead of the actual value (for example, Alberta) the merge
in Word inserts the AutoNumber associated with the value (for example, 1).
Any suggestions as to how to get the value and not the AutoNumber? Thank you.
 
Create a second column for your combo box that will have the value you want
to use. You can hide it by making the column width for that column 0. Then
when you need to use the value:
Me.cboProvince.column(1)
 
You probably use "LookUp" Fields in your Table(s) and the DatasheetView of
your Query picks up the "LookUp" also but the data stored is the StateID,
not the StateText.

Include the tblState in your Query and join it to the approp. Table in your
Query. Include the StateText Field in the selection and use this in Word
MailMerge.

Suggest you read the following article about LookUp Fields:

http://www.mvps.org/access/lookupfields.htm

--
HTH
Van T. Dinh
MVP (Access)


Sharon said:
For those fields where I use a combobox to pick a particular value (for
example, a province/state), I have trouble when I use the database as the
source for a merge in Microsoft Word. The original query looks okay but
after the merge, instead of the actual value (for example, Alberta) the merge
in Word inserts the AutoNumber associated with the value (for example, 1).
Any suggestions as to how to get the value and not the AutoNumber? Thank
Click to expand...
you.
 
Back
Top