Sub-reports requiring same input criteria

[guyver32]

Hi all,

Have a DB Report with multiple sub-reports requiring the user to input the same criteria for each of the subreports.
eg. Enter Staff ID, Enter Start Date, Enter End Date

Is there a way to enter the criteria parameters once and it be used for all sub-reports on the report instead of having to enter the same information 4 or 5 times before the report is generated.

Thanks

 

[boblarson]

Yes, use a form for input and reference the form in the criteria.

 

[guyver32]

Thanks for the reply Bob, can you tell me how I go about your suggestion.

Thanks

 

[boblarson]

Put the controls to enter that info on your main form and then in the criteria of the queries underlying the subforms:

[Forms]![YourMainFormNameHere]![YourControlNameHere]

 

[guyver32]

InputParameters

Hi All,

Worked through the help and with the aid of Bob figured out some stuff, but in the help on how to create a form for entering criteria, item 10 mentions setting the InputParameters on the form, but within the properties of the form/subforms I cannot find where InputParameters is or would go, any help please.


Regards

Guyver32

 

[boblarson]

See if this won't help: