Reports By Date or use Customer Report Menu Not Both?

[burrina]

I have a popup form that shows the list of ALL reports and you can then use a start and end date. Some Reports I do not want on this list as they could cause problems, Do I create a list of select reports but how then do I use a start and end date as my criteria for certain reports? How best to approach this?

[June7]

Don't understand the issue.

Are you building reports with parameterized queries? If you don't want a report to use start and end dates criteria then don't design the report to use them.

[burrina]

The Reports themselves don't have date criteria.I was using a form with the list of ALL Reports and then the user could choose a report from the list. There are some Reports I don't want on this list and there are some forms that build the Report from their data and so the Reports is essentially unbound, hence the need for this issue!

A dilemma but not a major show stopper. I am surely not unique to this issue unless I am just special? Hmm, I think not!
No doubt I will have to go back and redesign some forms to allow resolving this issue.

Thanks,

[orange]

Suggest you make a list of the Reports you want and use that for the list of Reports available for selection.

If reports need Report period start and end dates, then make that part of the openargs, or par tof the underlying recordsource for the report(s) involved.

[burrina]

Good idea. I don't know about the the Open Args thing. I will try and implement some code to open a date criteria form instead of the form itself first. Some Reports such as SubReports I dont want in the list so that option is out.

Thanks,

[orange]

Here's a post re OPenArgs
https://www.accessforums.net/program...ort-12506.html

You can probably find more in Access help, or google.

There is a sample program by Allen Browne that uses OpenArgs on a Report
at
http://allenbrowne.com/ser-50.html

Martin Green has a number of Access tips
Here's some about Dynamic reports.
http://www.fontstuff.com/access/acctut19.htm

[burrina]

Many Thanks for that Help.