troubleshooting Question

MS Access Query parameters in form for report

Avatar of rgagli1
rgagli1 asked on
Microsoft Access
2 Comments1 Solution857 ViewsLast Modified:
I need a report that has 2 parameters: division and type.  I want to create a form that lists all possible division and type accounts in a combo-box so that the user can easily select a value.  For whatever the user selects, I want it to populate the "Type" report.  How can I do this?  I created a query that forces me to type in the division and type.  I also have created a form that lists all possibilities but I cannot get it to go to the report.  When I open the report it still prompts me to type in the division and the type.  How can I get the form to talk to query to populate the report.  Any suggestions?  I would like the form to pop-up when the report is selected and then once the user selects both the division and type maybe they can press a button to generate the report.  
ASKER CERTIFIED SOLUTION
EMCIT

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros