A report that filters different results

[Jamesy_007]

Hey everyone,



Can I get some guidance.

I have this form with two buttons . one button Receipts [btnReceipts] filters a report on the individuals Total. If someone has no data to retrieve the report will not open by vba code. I have another button on the same form Yearly Report [btnYearly]. This button opens a report of the Total sum for everyone according to the year by criteria ... good. I can do this by creating two(2) reports similar but changing the criteria in the row source property sheet OK! not bad... But what would be really Kool is if this can be done, say generated from one Report where each button is clicked the Report filters in Total by individual and by year...

I know this is vba programming I hope this makes sense... am thinking I saw something like this in the Northwind db

[Micron]

research the On No Data event. I think that will do what you want - even allow you to present custom message when there are no records for the report, if you want to.

https://learn.microsoft.com/en-us/of....report.nodata