Multiple selections from multiple combo-boxes generating case-selections

[Andren]

Hi !
Maybe the WCVHNAP (World Community of Very Helpful and Nice Access Programmers) can help me with these two questions that softly are killing me.
It is like this - I want to do selections (for viewving and for producing reports). What I have is a Query-table (based on multiple tables). In that table I have stored code-numbers as well as descriptions. The code numbers were put there by the help of sevral combo-boxes (in an input form - taking their values from several stand-alone look-up tables). I can put code values into tables and then build queries holding code values and other info.
NOW - I want to be able to SELECT "other info (for viewing or for reports) BASED on SEVERAL INDEPENDENT combo-boxes in combination based on their code-values. How can I do that ? Then - How can I define a certain code-number (hold in the Query) by a certain label so that only labels show up in the combo-boxes for the report, when end-users should make their selections.

Thanks ..

 

[Rob.Mills]

Is each combo box defining a criteria for a separate field?

If so, in your query you can have each field reference its corresponding combobox.