Filtering a form or report by month is a common request, because users don't want to have to go and select the individual days for the start and end of a particular period. It is much easier to select just a year-month combination for the start and end of our search than it is to select individual dates. In this video, I show one of the more common methods of creating a "monthly" based search criteria for forms and reports. We'll create start and end combo boxes, load them with available selections, then let users choose those to filter not just our form, but also a reports that we launch on the same data. Related Videos: How to Use a Pass Through Query in MS Access - SQL Server Example https://www.youtube.com/watch?v=JCeEBb3mR7E How to Simulate Lag and Lead Window Functions https://www.youtube.com/watch?v=9iSuI3dR75o How to Filter by Month in MS Access Queries, Forms, and Reports You are watching this video now! How to Use Reference Expressions to Get Form Values in MS Access https://www.youtube.com/watch?v=I2JU95lnz_w How to Create String Aggregates in Microsoft Access https://www.youtube.com/watch?v=ItCS-g1K2zk For developers looking for a new role, check out and sign up: https://www.toptal.com/qKaO2b/worlds-top-talent Needing to hire technical resources for your project? Get the best: https://www.toptal.com/qKaO2b/worlds-top-talent Want to get access to premium content made just for you and have a chat with me? Find me on Patreon : https://www.patreon.com/mackenziedataengineering Demo of my BZ RDP Cloaker: https://www.patreon.com/posts/how-to-block-rdp-98471703?utm_medium=clipboard_copy&utm_source=copyLink&utm_campaign=postshare_creator&utm_content=join_link Want to work with me 1:1? Contact me today and book your free 20 min consultation! Contact form you can find at http://www.mackenziemackenzie.com/ Follow me on social media: https://www.facebook.com/mackenziedataanalytics https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering #msaccess #vba #dataengineering