How can I limit the number of records displayed in a subform, both when it is displayed in a view and when the detail is opened to edit.
We gather monthly statics on clubs in Africa. Years of data is collected, and I only want the user to see the current year at a time. Our main form has club info with a subform for attendance records.
In a test (which didn't work) I tried to just limit to the Month of November. Below is a snipit from the parent form code:
Weekly_Statistics
(
displayname = "Weekly Statistics"
type = grid
values = Nar_Stats[Month == "November"].ID
)