Problem filling textboxes from combobox

[reidn]

Hey, I am new to access and have a quick question.

I created a combobox that draws data (Workorder, Quantity, Country of origin, Customer) from a table with this info. When I select the workorder I want the other textboxes that I have to autofill with the other information from that certain workorder (quantity, COO, and customer).

I have the following code written to do this:

Private Sub Combo98_AfterUpdate()

OQT.SetFocus
Me!OQT.Text = Me!Combo98.Column(1)
JCO.SetFocus
Me!JCO.Text = Me!Combo98.Column(2)
CN.SetFocus
Me!CN.Text = Me!Combo98.Column(3)



End Sub

I added the set focus because when I first atempted to run it an error message popped up stating that the specified field could not be edited without focus. After that change was made I ran it again and this time an error message popped up saying that the field could not be changed because it is read only.

Please help me out with this
Thanks

[TheShabz]

You syntax should be:
Me.txtBoxName = Me.comboBoxName.Column(Integer) 'Note the first column is 0, not 1.
assuming both controls are on the same form, which I assume is the case seeing as though you are already using "Me".

There should be no need for setFocus.