Three combo boxes to retrieve one value

[Rob_McSmiley]

I need to return a value based on three combo boxes (I am not trying to filter the subsequent combo boxes).*

CboPhaseID - User selects which phase the cost should be based on (1=Phase 1, or 2=Phase 2)
CboCommunityRevenueSize - User selects the community size the cost should be based on (1=Small, 2=Med, 3=Large)
CboCurrentFinancialCapacity - User selects Capacity of the community(1=Limited, 2=High)

I have created a basic query where if I manually put in the variables it returns the cost*however I don't know how to build a query where the variables are inserted via the user selecting values in a combo box.

Based on the combination of the responses in the three combo boxes one of a dozen cost values $$ is returned into the PhaseCost field



Any help you can offer would be great!

 

[pbaldy]

The query can get parameters from the form, rather than manually inputting them.

 

[Galaxiom]

Refer to the combo values in the query designer as:

Forms!formname.comboname

Note that this returns the value of the bound column of the combo. It may be displaying a different column.