I have a form that shows a brief continuous overview of every record in my table. I want to be able to filter the date field titled "datecareplanmade" (CP Created on the form) by month and year. I figured out how to search for an exact date, but I can figure out how to look for a single month. I tried to do a combo box with a list of months, but I'm not getting the records I want to see, and I think it's filtering date fields I don't want it to filter. I know how to filter it my date, but I want the end user to be able to do it with minimal instruction.
Any help is appreciated. I'm still working on the aesthetics of the form, so please ignore misalignments.
Sorry if this has been answered already, I did a quick search and didn't see anything.![]()