Combobox returns null value for columns 3+

[El-d]

Hi All,

I've got a combobox that returns 4 values
eg
ID , Client, MinVal, MaxVal
4,SG,530,4500

Only the Client is shown in combobox. When I run the Row Source query it returns the 4 values as expected.
I am trying to set 2 other comboboxes to the min /max values

The min works fine but max returns null.
I've debug.printed
Debug.Print Me.Clientlist.Column(0)
Debug.Print Me.Clientlist.Column(1)
Debug.Print Me.Clientlist.Column(2)
Debug.Print Me.Clientlist.Column(3)

and get 4,SG,530,null.

I tried adding new columns and each one above the 3rd returns null.
Probably something simple I've forgotten to set but its driving me a little mad trying to find the solution.

Thanks,
El-d

 

[pbaldy]

Check the column count property of the combo. I'm guessing it's 3.

 

[El-d]

Thanks.

Thought I'd checked that...but only on the 2 comboboxes I was updating.

Damn, schoolboy error!

Cheers,
El-d

 

[pbaldy]

Happy to help!