Reference Drop Down Column In Query

[pjd218]

I have a table (PROJECT_TBL) that gets most of its data from drop downs from another query (CRITERIA_QRY). Column 1 is bound from the CRITERIA_QRY and is stored in the field CRITERIA_1, Criteria_2, etc. in the PROJECT_TBL.

What I need to do with a query on PROJECT_TBL is to be able to reference the bound column in the query.

The reasoning is that the Criteria table holds adjustments to pricing which is not stored in the PROJECT_TBL and I need to perform calculations on the based on selectin made in the PROJECT_TBL.

Not sure I explained this correctly but the bottom line is that I need the syntax to reference a column from a lookup field in a query that may be different from the bound field.

When I drop the Criteria 1 fieled into a query, it gives me the criteria description rather than the criteria id.

As always, tks for any suggestions.

 

[lameid]

=[Forms]![Form Name]![Combo Box Name]

 

[dhookom]

You can't reference an unbound combo box column in a query criteria. The common solution is to create a text box in the form that references the unbound column. Then use this new text box in the query criteria.


Duane
Hook'D on Access
MS Access MVP