option box for query?

[can]

Hello...

Here is what i have, a database with names, addresses and all sorts of information.

I have made an answer query that the report form is based off of with all the fields needed. The fields will not change from here on out.

I also have a form, which I have successfully bring up the report.
(big step for me, newbie here )

So, now, new queries will have to be made from the form, which is where I get lost.

Sometimes it will need to be filter based on zip code, mostly thats what it will be, but I have to have the option of doing it other ways.

whats the best way to go about this?

pleaes be specific as im new to this kind of thing.

Martin

 

[can]

oh yeah

is there any way for the query button to not bring up the report, but just run the query?

 

[RuralGuy]

Could you post the code you use in your form to run the report? If it is "DoCmd.OpenReport" have you tried the "WhereCondition" parameter?

DoCmd.OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs)