Drop Down Boxes define the report.

[MacoJaxs]

Hello all.

If there is a thread already out there for this, please let me know and we won't reinvent the wheel.

I'm looking to build a form that has drop down boxes with various data-specifically, weapon system, start date and end date.

How can I create a report based on my user's variables?

Thanks.

 

[csou5555]

Create a form, containing your drop-down, start and stop date fields. At the bottom of the form, place a button that will open your report. In the query that generates the report, for each of the fields you want limited by data from the form, enter something like the following in the criteria line: [Forms]![frmClient]![Client] (this will look at the form [frmClient] for the value in the drop-down [Client] and filter the query/report based on that value. Use the same logic for the date fields, and it will limit the report based on those values as well (something like "Between [Forms]![FrmClient]![BegDate] And [Forms]![FrmClient]![EndDate]"). The only caveat is that the form must remain open while generating the report.

You can also define global variables and assign the data to them, but this method is much easier. I use it all the time.

Hope this helps!