referencing multiple fields from a list box

  • Thread starter Thread starter Ben Armfield
  • Start date Start date
B

Ben Armfield

I would like to be able to use the value of the second
field displayed in a list box to peform calculations, but I
haven't been able to find a way to identify any but the
bound field. Any help would be greatly appreciated. Thanks
in advance. Ben Armfield
 
Hi Ben,

You can reference the columns in a listbox or combobox by
their relative position. Bear in mind that the columns
start counting from 0 and not 1 as you'd expect.

=ListBoxName.Column(1)

would refer to the 2nd column

hth

chas
 
Back
Top