Hi
OhioSteve gave you the answer:
"You would make the control source for the subform records be a query. Then that query would have a date parameter.
When the button was pressed, it would change the control source for the subform and refresh the screen."
but to flesh it out a little what is teh existing recordsource of your sub form?
If it is a table, then make instead a query based on that table.
So either way you have the rowsource as a query, with not restrictions (criteria), now make a copy of that query and set a critera on the date column of > DateAdd("yyyy",1,Date())
Say the two queries are called queryAll and queryYear.
Set the recordsource of your subform to queryYear
In your button on click event put
Me.MySubFormControl.FORM.Recordsource = "QueryAll"
Me.MySubFormControl.Requery
you need to use your own control and column names of course
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -
UK