More than one parameter

[Guest]

I have a form with only combo boxes on it that populate from their own
tables. I want to run only one query with 8 parameters to build my reports
from. So, I have a seperate form with these 8 combo boxes I want to use as my
parameters. If I only want to search according to one piece of criteria, I
choose my option in the specific combo box and runt the query, and for more
than one criteria, I want to choose from more than one combo box. If I'm not
using all 8 criterias, I dont want to be prompt in the fields I dont use. Is
that possible and how?

Appreciate any help

Johan

 

[JohnFol]

Can I presume the query that the report is based on references the form with
the combo boxes? If so, you should not be prompted for the values as Access
will automatically get the values from the form.

To answer a slightly different question, if a combo has not been selected
and you want to ignore the parameter, simply do a

=Forms!ParameterForm!ComboBoxWithValue OR
(Forms!ParameterForm!ComboBoxWithValue is null)

 

[JohnFol]

PS Have a look at the Sales By Year example report in NWind

 

[Guest]

Thanks a lot. Working a 100%
Like [Forms]![frmYourForm]![cboCombo] & "*"