I have a comboBox in a form that takes data from a table, and adds it to another table. The form displays the info. in a textBox (txtBin). All works great till I get to the number 91 and the txtBin will show "Top Red Bin 1 Row A Col 1 Comp 1", when I select 90 in combBox I get "Res 90 Row E Col 6 Comp 3" in txtBin. If I select 100 I get "Top Red Bin 10 Row A Col 3 Comp 2". If I select 120 I get "Top Red Bin 30 Row B Col 4 Comp 2". It seems to add the first two numbers and drop the third. All numbers below 90 work as intended in the textBox on the form. The correct Data is always in the updated table location as intended by slection from combBox. The problem is just inMe.cboLocation.Column(1), all the other info. is correct.What can I change or look for to fix this problem? Be glad to supply more info. Thanks! MS office 360
Code:Private Sub cboLocation_AfterUpdate() On Error Resume Next Dim Bin As String Bin = Me.cboLocation.Column(1) & " <strong>Row</strong><em> " _ & Me.cboLocation.Column(2) & " </em><strong>Col</strong><em> " _ & Me.cboLocation.Column(3) & " </em><strong>Comp</strong><em> " _ & Me.cboLocation.Column(4) Me.txtBin = Bin End Sub