multiple subreports requesting same criteria

[jcright]

Hello all,

I have a main report that holds 4 subreports. Each subreport is based on the same criteria which is a month/year combo.
When I open this up, it repeatedly asks me for the same criteria. I'm trying to figure out how to enter the criteria once.

Any thoughts?

[Bob Fitz]

Hello all,

I have a main report that holds 4 subreports. Each subreport is based on the same criteria which is a month/year combo.
When I open this up, it repeatedly asks me for the same criteria. I'm trying to figure out how to enter the criteria once.

Any thoughts?

If you are saying that all the sub forms reference a combo box on the main form to restrict the records in the subform, then keep in mind that the subforms actually open before the main form opens. Perhaps set the RecordSource properties of the sub form once the main form has opened.

[jcright]

Bob. No, it wasn't going to combo boxes. Each subreport had a query that asked for a parameter. Based on that parameter it would filter information for that report. What I finally figured out is that I can do a master/child link of the subreports to the main menu. Then it only asks me for the parameter once.

[Micron]

If you are saying that all the sub forms reference a combo box on the main form to restrict the records in the subform, then keep in mind that the subforms actually open before the main form opens. Perhaps set the RecordSource properties of the sub form once the main form has opened.

While that is true for subforms, I'm pretty sure that it's not the same for subreports, which is what the OP is using.

Ideally, you shouldn't be asked to input the value even once. I take it that the field containing the value is not on the main report, or the value isn't making it there.

[Bob Fitz]

Each subreport is based on the same criteria which is a month/year combo.

I assumed that your reference here to "combo" meant a combo box.

I'm glad you found a solution.

[Gicu]

Most developers prefer to use a "reporting" form where you would set the desired criteria in certain controls (textboxes, comboboxes, etc.) instead of prompting for the criteria in each report's record source.

https://www.oreilly.com/library/view...7/ch01s02.html
https://docs.microsoft.com/en-us/off...-qbf-technique

Cheers,

[jcright]

Yep, I totally get why you would think that. So when I open my report it asks me which month and year I want. Each subreport uses that month/year criteria.

Unfortuately it doesn't work as well as I originally thought. This is a commission report for salespeople and the pay struture is convoluted. At the moment, I'm just trying to get a report that actually works. For the most part, I've done that...now I need to go back and try to automate certain things, like selecting which month and year to do the report on. Some sales people don't normally sell something in a month and there are overrides involved on deals, etc. So linking the master/child works, but it seems to only work if the person made a sale. If they didn't, then it comes back blank....its kind of like it maybe looks at the first report, sees it is blank and then gives up despite the fact that other subreports have information. I'll have to figure this part out later. Only a couple of people are like this, so it isn't too horrible. What I really need to do is figure out how to make one report that can pull up each salesperson based on the pay period and send a report to them via email. Learning as I'm going.