Filter subform by date
Posted on 2003-10-23
Hello dear expert friends,
I've got to make a form with a subform in it, that is sorted by date. The form (frmPepijn) has a combobox (cmbWeek) with all dates in of all the mondays of the year, so you can view the data of the whole week.
the subform has a field event_planning_date, that is used to sort and to filter on.
Now i would like to have the subform filtered when i update the combobox when the date is the same or 1 more, 2, 3, 4, 5 or 6 more.
Thanks in advance,