Problem with populating textboxes in relation to drop down list
 

I have a drop-down list in a form, a number of text boxes are then populated
from this value. For example the Date text text box is to be filled with
data to the left of the tourref value etc.
I have used the ".Column()" property eg.

'On Change of Tourref Drop-Down
Private Sub tourref_Change()
DateText.Value = tourref.Column(-1)
CountryText.Value = tourref.Column(1)
PlaceText.Value = tourref.Column(2)
AdultText.Value = tourref.Column(3)
ChildText.Value = tourref.Column(4)
End Sub

However, this does not work on the "bookings" sheet at all. But does work on
others. Any ideas why? or how i can do it differently?
Thanks
--
Cheers,
Ben

Remove your.tonsils to reply
"You only live once but if you do it right once is enough!"