Filling a combox y clicking list box

[Georgekobanda]

I am working on a project and i would like to click a list box then the values get filled in a combobox. It works well with TextBox but it doesnt work with combobox. Below is my code combo1 is a combobox field

Private Sub listboxmachine_Click()
With listboxmachine
combo1.Value = .Column(0)


Litres.Value = CLng(.Column(1))
End With
End Sub

Thank you

[ranman256]

you can do:

combo1= .Column(0)

IF .Column(0) exists in the combo.
but if you use keys and the combo has 2 columns like:
1, Land Line
2, Cell
3, Work

and the combo is bound to Col 1 (the key)
then you cannot assign "cell" to the combo box. You must assign 2, and CELL will appear.

[Georgekobanda]

Thank you for your quick repsonse, otherwise, if i try implementing this code, i get an error of Invalid or unqualified reference