Issue with combo boxes keeping correct selection (1 Viewer)

[tmyers]

I have been having an issue with combo boxes on my forms keeping the selected value when records are copied.
Here is a snip of what the form and combos look like before the record is copied.

However after the record is copied the combos lose their value. Is anyone able to explain why this happens? Is it an issue with how they are bound? What makes this even harder for me to figure out, is if I switch what column they are displaying, the maintain their value. The problem is it will display their ID number, which means nothing to the user.
,

The form is a subform and the combo is bound to TypeID, but retrieves the name via a query as a row source.

The subform that contains this is:

Any ideas?

 

[tmyers]

I would like to say that I have this issue in several places. All are different sub-forms serve different purposes, but each displays the same thing, and they all do it.

 

[Ranman256]

if you bind the combo to col.1 ,and pick A12, the result is A12.
you can still get the count from the 2nd col via: txtbox = cboBox.column(1)
(in vba, columns begin with zero)

if you bind the combo on col2, and pick A12. the result will be 53.
you willl no longer see A12.

Have 1 box get the Text value(combo bound col1) , and another text box grab the Numeric value. (=cboBox.column(1) , in the afterupdate event)
there's no need to have 2 boxes to collect the 1 value. The combo gives a value.

 

[tmyers]

if you bind the combo to col.1 ,and pick A12, the result is A12.
you can still get the count from the 2nd col via: txtbox = cboBox.column(1)
(in vba, columns begin with zero)

if you bind the combo on col2, and pick A12. the result will be 53.
you willl no longer see A12.

Have 1 box get the Text value(combo bound col1) , and another text box grab the Numeric value. (=cboBox.column(1) , in the afterupdate event)
there's no need to have 2 boxes to collect the 1 value. The combo gives a value.

Edit:
Misunderstood. The count is displaying correctly. It is just type that is the issue. The count is bound to a query and displays something different. That works fine.

 

[Pat Hartman]

Fix the properties of the combo so that they hide the ID but show the text string. There's something wrong with the properties. It also looks like you might be using a table level lookup. That is a problem to begin with. Get rid of the table level lookup. Use combos ONLY on forms/reports, Never on tables.