Report criteria request

[whitestone]

I have three tables in my database, one of records (with various columns of information), one of groups that the records fit into (with just a group ref and definition) and a junction table that links the two (as there is a many-to-many).

I want to have a report that brings up the records for a particular group. Therefore I have set up a query and report that displays all the records under a specific group (defined in the query) and that works fine.

However, what I really want is for another user to be able to open the report and for it to ask ‘Which group would you like to display?’, then they could choose the group from a list (based on the ‘Groups’ table) and report on that. This would be very useful, as they would not have to know how to change a query to be able to run the correct report.

Is this possible? And if so can anyone give me any tips?

Many Thanks

 

[Mile-O]

Use a form with comboboxes, listboxes, or textboxes...

In the query that runs the report rather than hard code the criteria set the criteria to the form.

ie.

[Forms]![MyForm]![MyTextBox]

Put a command button on the form so that when clicked it can check for valid criteria, check if the query returns any records, and, if so, open the report.

 

[whitestone]

Thanks

That works well.