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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Boxes - DISPLAYING multiple fields after choice is made 5
Multiple Column List Box 4
Access Form - Lock Fields from Editing 0
Calculated Field 3
How to save multiple selection from a list box in a bounded field 1
Prompt for a subform text field 2
Access MS access forms list box problems 1
Listing Field Descriptions in List Box 4

Back
Top