Form-based Parameter Query

[Scott A]

I'm working with two form-based parameter queries, each of
which allows the user to select their parameters from
combo boxes. The query is set to use the criteria
provided in the form using [Forms]![FormName]![Control],
or the user can leave the combo unused (or []![]![] Is
Null).

One of these works just fine - it provides results with
any combination of criteria, using four variables.

The second form is not working so well. It is virtually
identical to the first query, except that I am allowing
the user to input up to six variables using the controls
on the form. When running the query, it will take some of
the parameters selected, and ignore others.

One note, and something I'm wondering about - I haven't
declared any of the parameters' data types in the Query
Parameters window, and am wondering if that will help - or
maybe the SQL string is just too damn long to execute
properly, I'm not sure.

If anyone out there has an idea as to how to make this
work, I'm very keen on it.

Thanks,

Scott

 

[Scott A]

Wouldn't you know that after closing and re-opening the
database file it works...

Anyhow, still interested in hearing from any of the MVPs
as to whether I should be declaring the data types in the
Query Parameters window - specifically when I'm using
combo boxes on a form as the source of the parameter (do I
enter the data type of the looked up value, or the key
field?) OR - do I forget about it and leave it as is.

Your thoughts?

Scott