By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,325 Members | 1,886 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,325 IT Pros & Developers. It's quick & easy.

Running Reports from Multiple Parameter Forms/Data in Access03

P: 57
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.

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?
Aug 12 '08 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,661
I would consider using a filter when opening the report.

Basically, you use VBA to formulate a simple --> complicated WHERE clause string depending on how many of your form controls have data entered into them.

Open the report (DoCmd.OpenReport(...)) passing the parameter just worked out.
Aug 14 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.