referencing dropdown column diffferent to boun column

[dubmunkey]

hi,

im wanting to reference a value of a dropdown which is already serving a function - the dopdown already has it's bound set to 3 but i want this new function to refercne the second column-

im tyring:

"Tutor = '" & Me.ComboStaff.Value(2) & "'"

which isn't working- how do i reference the second column of a dropdown if its bound to its third?

cheers

dubs

 

[Cosmos75]

"Tutor = '" & Me.ComboStaff.Column(1) & "'"

Using .Column(0) refers to the first column.

 

[dubmunkey]

nice one, ill try that

dubs