Subform not displaying in Report for last day of month

[Mike Partridge]

We have a daily report which contains multiple subforms. This report gets run with an input parameter of a selected date. When the report is ran with the last day of the month, the subform does not show up in the report. If the user selects any other day besides the last day of the month the subform shows up fine. When the user runs the subform on its own and enters the last day of the month, the data shows up fine, same goes for running the query that the subform is based on. Any ideas as to why the last day of the month being passed in from a report to subform as the input parameter would cause an issue? (Also, the date is simply selected from a calendar residing on a Master report, then the user selects a report and clicks run)

[NeoPa]

Honestly Mike, no.

Your question leaves us with so little info to work with. How can we possible guess what is wrong in such a project.

Is it multiple subforms at issue here, or The subform, as you say later?

Which relevant settings are set, and how?

[Mike Partridge]

We have an access report that contains 5 subforms. This report gets passed in a date which gets passed into all 5 subforms in order to get data for that particular date. 4 of the subforms work absolutely fine, and 1 subform works except when the last day of the month is passed into the report. So the particular subforms is the issue, BUT, If I were to just run the subform on its own (or the stored procedure), it requires a date, so I pass in "11/30/2010", it works fine and displays the data requested. So the bottom line is, the stored procedure works when supplied the last day of the month, so does the subform, but the subform does not show up in the report when these particular dates are passed in, but work for any other day of the month.

I am not sure which settings are most relevant, but one of the other subforms that always works has all of the same property values within the design view. Please let me know what other info you need!

[NeoPa]

How is the date passed?
What about the design of the subforms allows it to react to the date value passed?
What are the names of the Subform controls on the report, and the items contained therein (presumably reports)?