combo box column 1

[jake7363]

Hi,
I have a combobox with three columns, and the bound column is column 1. With the following code, I have tried to make column 3 visible in a text box:


Private Sub jobName_AfterUpdate()
txtJobDesc.Value = JobName.Column(1)
End Sub

However, this is not working.

Any help will be greatly appreciated.

Thanks in advance...

jake

 

[ZmrAbdulla]

txtJobDesc.Value = JobName.Column(2)


________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[jake7363]

Thanks, I noticed that I had the wrong column mentioned; but the problem is that NOTHING shows in the text box...

 

[ZmrAbdulla]

syntax is correct..
Although it is not going to affect but..Is your textbox locked?

and how about checking data
[tt]
Private Sub jobName_AfterUpdate()
MsgBox JobName.Column(2)
End Sub[/tt]

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[jake7363]

The message box worked fine. It showed the correct data. The text box is enabled and NOT locked. I am at a loss... I even did a "compact and repair the database" and still the same thing.

I do have a remark, although I don't believe it should matter...

I am using a table as a Lookup as the row source. Would that matter?

 

[ZmrAbdulla]

try it with another textbox

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[jake7363]

Yup - that did it. Thanks Much!!