Combo Box causes Append Query to Store Wrong Date in Table

[michael_bsog]

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.

[ranman256]

if the combo box is BOUND to the index, then it will send the index.
if the Assign# is in another column, then do this:
when the user picks the Assign# in the combo, write the # to a text box in the afterupdate event. (it doesnt have to visible)
then the query can use the textbox in the query

sub cboAssign_afterupdate()
   txtBoxAssign= cboAssign.column(1)          'NOTE: in vb code, columns start with zero, so col(1) is the 2nd field IN the combo box
end sub

now run query that appends txtBoxAssign.

[Micron]

Perhaps you have set the bound column to be 0? That will cause the list index to be the bound column. Perhaps you meant to bind to the assignment number and that value is in column 1?