I have a table populated in a form by two combo boxes. One combo box links to a table of available assignments. The other links to a table of available personnel. By using the two combo boxes I have a table with people assigned to assignments and all of their other associated data, so that I can mail merge to Word. I append this data to a temporary print table.
The problem is that the assignment combo box is storing a list index (the assignment number is itself the primary key for the assignments table from which the combo box is bound).
SO, when I mail merge, rather than an assignment number like "094-1029", I get something like "5" or "6" which corresponds to the order the assignment number was placed in the list.
My question is, how do I force the append query to append the actual assignment number and not whatever list index or bound value Access is using to associate with the assignment number.