I have looked for some help on this and this article/thread was as close to what I was looking for as I could find.
http://bytes.com/forum/thread603918-...ter+Query.html
My only question is the end of the article talks about subforms and such and I don't think that's what I'm looking for exactly. My question is this:
I have a query named Final_Results with the following fields:
Position, E_Year, E_State, E_Type, Seat_District, Candidate, Party, Votes
This query contains election data from Presidential races, Senate races, Governors, Representatives races for all 50 states. In the data, the Seat_District might be null if it's a President/Governor position at stake. The rest should contain data.
What I'm looking for is the easiest manner to have 1 selection form to be able to output the most appropriate query lines for each of the 5 parameter fields (Position ---> Seat_District)
A user could choose any number of those 5 fields to query on, from Representative 1992 Maryland General Election, District 6 to 1992 alone.
What is the best manner to parse this query via form and then have that data outputted onto a custom made report for each contingency in criteria selection?
I hope this is clear. Basically 5 fields that may or may not be used in a parameter query and then utilized to fill in a report.
--- Update ----
I've gotten this form and filter to work properly by following the above link. However, the output is a form; not a query or anything I can then use in a report based off the filtered information.
Instead of the OpenForm command, is there an OpenQuery command that would only display the filtered information, making it usable for any number of reports?