Report/Subreport criteria issue

[DblDogDare]

All,
I have a report that is based on a Like [type] criteria query. I would like to have a subreport based on the same query to show a list of different data. The problem I am encountering is a prompt several times for the [type]. I want to only have to type the field name once. I basically want to pass the same criteria from the report to the subreport. Any ideas are greatly appreciated

 

[jeremie_ingram]

Instead of the parameter query approach, I would have the user either select from a combo box or enter into a text field the criteria for the report. This would allow you to refrence the field rather than prompt for the information. Placeig the text box/ combo box on the form where the click the cmd button to create the report would be the best option, or you can put it onto a seperate form and set it up as modal and just use it to "capture" the input from the user.

 

[DblDogDare]

Almost there

Jeremie, Thanks for the reply. I resolved the issue of the multiple "type". However you have peeked my curiosity with the combo box. I have a switchboard. It would be nice for the users to be able to pick a button, have a combobox open, and select one of the projects and have the report open up from there, instead of having to type the project name. First off, they would have to know the exact name. I know how to create the combobox as a form, but how do I reference this combobox to an already created report based on the combobox criteria?

 

[jeremie_ingram]

Here is what I have done in the past and found to work nicely.

First, the useres navagate to the menu for the reports, the select which report they want via the menu. After they make thier selection a small form appears offering them the ability to select (from a combo box) the criteria for the report. Once thier selection is made, the after update code kicks in opening the form which is based off of a query with the criteria set in the proper field to the combo box text.
You could allow such an item for actual report selection as well, but I finde menus are better suited for that.

 

[jeremie_ingram]

I have attached a small mdb that demonstrates the theroy/idea