More than one parameter


G

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
 
Ad

Advertisements

J

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)
 
Ad

Advertisements

G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top