Text box that pulls values based on 2 dropdowns

[stotts04]

I am looking to create a textbox that would pull information based on what is selected in 2 dropdown boxes.



For example:

I would have a table that looks like this:

Column1 Column2 Column3
Hat small 5 dollars
Gloves medium 7 dollars
Pants large 10 dollars
Shirts 12 dollars
15 dollars

dropdown 1 would select from Column1
Dropdown 2 would select from column2

The textbox would depend on what is selected from what is selected in both dropdowns.

Say they select Hat and Small. The textbox would return 5 dollars.

Does anyone know how i would setup the textbox to pull that information?

[orange]

So your table has 3 fields
Item
Size
Cost


Concept is:
First Combo (Rowsource)
Select Distinct Item From MyTable

Second combo(Rowsource)
Select Size from MyTable WHERE Item = Combo1

There is a great tutorial at Datapig Comboboxes

[June7]

Have dropdown 2 include Column2 (Size) and Column3 (Price) - a multi-column combobox.

The textbox ControlSource can be an expression that references Price column by index:

=[comboboxname].Column(1)

Column index begins with 0 so Price column is index 1.