Referencing Dropdowns to multiple fields

[John Mundy]

Hello, New user here, so I'm sorry if this problem has been addressed before.

I am creating a form that has a dropdown menu consisting of data from a table I have created.

There are 4 columns in this table: "Model", "Total Cooling", "Make", "Net Cooling".

When the required row in the dropdown menu is selected, I have another field in the form that shows only the "Total Cooling" part, which is then used for some calculations elsewhere in the form.



The problem I am having is that I also need a field that references the "Net Cooling" part of the selected dropdown field, so that further calculations can be made from that field in yet another part of the form. Whenever I reference the dropdown, it only shows up the "Total Cooling" part in all fields that link to it. Is there any way of specifying exactly which column I can reference from the dropdown that is selected?

Thanks in advance, and I am aware that it will probably be something really simple that will embarrass me!!! haha.

[boblarson]

You can reference specific columns (as long as the combo's COLUMN COUNT property is set to the appropriate number of columns in the combo's row source).

=[ComboNameHere].[Column](1) * [TextBoxNameHere]

Column(1) refers to the second column as it is zero-based. So Column(3) would be the FOURTH column.

[John Mundy]

Thank you, that helps a lot.