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.  

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