Text Boxes dependant on Combo boxes

[dark11984]

I'm trying to get to three text boxes on my form to be dependant on a combo box. I can get TxtPop to work but not the other two.

I thought i had done this before and had problems. but i'm not sure why its not working this time.

If i change the columns for TxtProdcd & TxtDescription to column 2 it works, but when i cahneg back to column 3 & 4 nothing happens.

Any ideas?

Private Sub CboPONo_AfterUpdate()
    Me!TxtPop = Me!CboPONo.Column(2)
    Me!TxtProdCd = Me!CboPONo.Column(3)
    Me!TxtDescription = Me!CboPONo.Column(4)
End Sub

Cheers

 

[ghudson]

Just in case...

.Column(0) is the true first column
.Column(1) is the second column
.Column(4) is the fith column, etc...

Is there really any values in all those columns?

 

[pbaldy]

Also make sure the Column Count property of the combo is set appropriately.

 

[dcb]

I have found that if your column count does not match your underlying query you can "lose" the values...

IE if your row source has 5 rows and you only want to see 1
Instead of:
column count = 2
0;2.5
Use
Column Count = 5
0;2.5;0;0;0

 

[dcb]

Also make sure the Column Count property of the combo is set appropriately.

And I was busy typing all that time.....

 

[pbaldy]

Fastest fingers in the west!

 

[dcb]

Fastest fingers in the west!

NO - Just older - I had to go and test, you knew....

 

[dark11984]

column count fixed it... I should've known that! thanks guys