Creating Reports from data selected by user

[kirel]

I have created a tally keeping database, and i want to be able to select certain data in a window that will auto make the report,

For example i select a campaign code of t39 and the date and the user who as done this, and i press create and it makes that report.

i know it can be done, but i have having trouble in doing so, if anyone can help i would be very grateful.

 

[rodrigr]

If I understand you correctly you are looking to use a form to select criteria for a report. If so, try this...

Create a query that contains the info for your report.
Base your report off of that query.
Create an unbound form that the user will use to select the criteria for the report. (Hint: Listboxes and Combo Boxes are better that user typed criteria).
Then return the the query you created.

In the query criteria field for each user selectable item type the name fo the control that you made on the form.

For example:
If my criteria form (named "Criteria_Form") has a field that I named "Month_Control" and I want the data selected in "Month_Control" to determine the data in my query under the field "Month_Published" then in my query I would type [Form]![Criteria_Form]![Month_Control] into the "criteria" line under the Month_Published field.
*Keep in mind for this to work the Criteria_Form has to be open when you run the report.