I use code, so I don't know if this is the best asnwer for you or not, but I'm sure the same thing can be accomplished with macros or what not. I would create a separate form, or at least an inputbox (a function) popup to get the requested month from the user, and then use that input to filter the month with for the "where" condition of that report. In code you would first construct the where condition string which would filter the report, and then use the command to open the report on those filtered by those conditions. Here is an example of a "where" string I constructed using Month and Year objects on my form to filter a report by month and year, and an example of the command that would open the report to be filtered by that where string.
Here is the simplified version:
Dim where As String
'Filters [Month] field of query by cbo box named Month, etc.:
where = "[Month]=" & Month & " And [Year]=" & Year
'Opens the report using the where condition (in print preview mode)
DoCmd.OpenReport "SupervisorScheduleInfo", acViewPreview, , where
Code like this could go on the On Click event of a button on the same form where the user enters this information.
|
