Populating Text box after selection from Combo Box

[coach32]

I have a table called 'Reasons' which has 3 columns of Data.


ID - Number - Reasons
I have a form that has data entered into it and this transfers onto a table (Complaints)
On my form I have a ComboBox which consists of all the Reasons from the Reason table.
I then have a text box that I wish to populate with the corresponding number of the reason. (EG: Duplication = Reason # 8)
So I have placed the following code in the OnChange field of the TextBox.

Private Sub Text36_Change()
RowSource "Select ID, Number, Reason From Reason"
Me.Text36 = Me.Combo39.Column(1)
End Sub

Why is it that when I place the Reason for the complaint on the form and then create a new record, the actual
reason number has placed itself in the Reason column and not the Reason # column in my main Table?
Any guidance/assistance would be greatly appreciated. Thank you in advance.

[pbaldy]

Not clear on the question, but you realize the Column property is zero based, so your code refers to the second field, "Number"?

[coach32]

Complaints.mdbI do apologise. I knew as I was writing it I wasn't being very clear.
I have attached a sample Database. When I data entry into the Form, I select Incorrect Buyer.
When I do this, I want the number 3 to appear in the reason # field on the Complaints Table.
Instead the 3 places in the Reason field.

[pbaldy]

I think you want that in the after update event of the combo, not where it is:

http://www.baldyweb.com/Autofill.htm