Can a Parameter Query with Several Input Dialog Boxes Have One (Or More) That are Optional?

[tatihulot]

Hello, I have a question about creating parameter queries.



Is it possible to create a parameter query with several separate inputs, but not ALL of the inputs are mandatory?

For example, my movie collection database has fields for Director, Silent, and Foreign.

The Foreign field is a Yes/No checkbox. So is the Silent field.

I want to create a parameter query where you are asked for each value, separately. In other words, three separate dialog boxes.

Is it possible for one or two of those dialog boxes to be optional? For example, is it possible to skip the third parameter query’s dialog box, which says, “Type Yes for Foreign movies.”?

Or, can the Director dialog box be optional, so I can just query all of the foreign movies that are also silent?

I haven’t tried doing this yet. I figured I’d ask about it before doing it, so that I know the proper procedure before undertaking it. Thank you.

[Welshgasman]

Do not do it

Create a form for all the parameters.
Then you can decide what is mandatory and what is not.

[June7]

Something must be input. Do you want AND or OR operators? Example:

SELECT Holidays.HolID, Holidays.HolName, Holidays.Qty
FROM Holidays
WHERE (((Holidays.HolName)=Nz([Enter hol],"NewYears")) AND ((Holidays.Qty)=Nz([Enter qty],1)));


Again, don't do it (I NEVER have). Input boxes would just be a source of frustration for user. Cannot validate input.

Review http://allenbrowne.com/ser-62.html

[tatihulot]

Thank you. I didn't think it would be the best way to do things, but I wanted to ask. Since I'll be the only person using the database, it would probably be easier for me to write specific queries.