Making parameter query ("or) stop after any parameter is satisfied?

[PATRICKPBME]

I presently have buttons linked to reports which in turn are linked to queries. Specifically, I have 8 separate buttons to allow folks to search 8 different ways. With the information these folks are going to want, and with me developing a query and button for each, I feel I may end up with literally dozens of buttons.

I was thinking that I could do an "or" query and once any one of the options is satisfied by the user I would like the report to be generated after they click "OK" instead of it going to the next optional field. Even better, I supposed, would be to have maybe one button with a drop down menu so they could select how they wanted to search. In other words a "Search By..." button that when clicked would present a menu that let them choose, for example, name or address or state, or any by any search fields available to them. Almost like embedding all my buttons into one I guess.

Can't seem to find the answer in my "Access 2010 Step by Step" manual so once I again am turning to the pros!

Thank you.

[orange]

Review this material from Martin Green re Dynamic reports.

Good luck.

[NTC]

well your post involves 2 separate things:

* if you have 1 button per report/query but there is becoming too many buttons; then using a list box or combo box instead means that then you are moving the Open Report Argument from its own button to a different control - possibly exchanging arguments via if/then - - and really it is all about what kind of user experience you want but fundamentally just rearranging how the existing Open Report Arguments are triggered.

* different from this is the idea of building the query depending on what they want - this is a lot trickier - it is O's link above and you'll find other info online about Query By Form.....In this situation you are dynamically constructing the SQL statement itself. Keep in mind on this that while you can manipulate the criteria of a query dynamically i.e. (red widgets only) - the nature of the report object does not accommodate one adding or eliminating fields themselves. Which is to say the Color field can have criteria applied (i.e. only Red) but the Report cannot dynamically add/remove the Color field itself. So your report layout does not dynamically change.