Paramenter Options for Running a Report

[need_help12]

Good morning. Relatively new to Access, and the build I'm doing needs to be very simplistic. In this case, I'm building a simple database to store vendor data and need to be able to retrieve this information from the table in which I store it.

In this case, I've built a simple report "Vendor by Site" which prompt a parameter value to be entered to select the site you're looking for and it'll display the info accordingly. The issue I have is I cannot assume my end-users know all the sites off the top of their heads, and I would like to give them options (be it check-boxes, combo-box, whatever my options are) to select from and have the report run from their selection.

Is this possible?

I've attached my dummy database to be more clear. I appreciate any assistance anyone is willing to lend.

[pbaldy]

Create a form with a combo for the user to select from. Change the query criteria from [Please Enter Site] to

Forms!FormName.ComboName

and run the report from that form. You have a lot more control when you use a form for user input.

[need_help12]

Thanks for the help, pbaldy. I followed for the most part, but I dont think I did it correctly. I created a form and changed the query as you stated below, but when I run the report, I still get a parameter box with the code I wrote in shown. I think the end goal here to to show the combo box on the frmVendorSite form I created, but obviously didnt link it correctly.

Would you mind looking?

[pbaldy]

It appears to be working fine. The query won't open the form for you. Typically you would open that form, let the user select their criteria, and have a button on that form to run the report based on the query. It can get more sophisticated, but that's the basic setup.

[need_help12]

Aaah, ok. There's our disconnect. So I need to have end-users go to the Form first, pick the location, and then I need a command button from the form to run the report. Thank you, sir.

[pbaldy]

Happy to help. You can open the form in dialog mode from the open event of the report as well. Dialog mode will make the report wait for the form to be closed or hidden (which is what you'd do) before it finishes loading.