ACCESS 2003 how to filter the report  based on selections from combo boxes

how to filter the report based on selections from combo boxes
I have a report and I want to select values from field to exhibit only some data.
So from a form I push a button.
Until now it exhibit the report with all data.
Now I want a box first exhiibit 5 combo boxes where I can select or not values in order that
only some data are present in the report.

The only solution I found is
in source data properties of the report to specify the following query
SELECT collab.MATRICULE, collab.NOM, collab.PRENOM, collab.CENTRECOUT, collab.LIBELLE_CC, collab.MANAGER_CC, collab.LIBELLE_UNITE, collab.MANAGER_UNITE, collab.CATEGORIE, collab.exercice, collab.SOCIETE FROM collab where (((collab.exercice)=[annee exercice ?])) and (((collab.LIBELLE_UNITE)=[libelle unite ?])) and (((collab.MANAGER_CC)=[manager CC ?])) and (((collab.LIBELLE_CC)=[libelle CC ?])) and (((collab.LIBELLE_CC)=[libelle CC ?])) ;

but it exhibit 5 texte fields one after one another but not combo boxes and it is too long.

So if anyone has a solution.



Best DavidStart Free Trial