I have been reading several different post, but have not yet found one that I understand to accomplish what I am after.
My form is a split-form and contains a date column (the table behind the form is the data type Date as well). I am trying to use a value list combo box to filter the form by months, so the combo box will display January, February, March etc. and filter the form accordingly.
So with the column being formatted as 01/01/21, how could I use the combo box selection of January to filter to that?
My form is a split-form and contains a date column (the table behind the form is the data type Date as well). I am trying to use a value list combo box to filter the form by months, so the combo box will display January, February, March etc. and filter the form accordingly.
So with the column being formatted as 01/01/21, how could I use the combo box selection of January to filter to that?