Filter Customer Lists by DOB in Forms/Combo Boxes

In this Microsoft Access tutorial, I will show you how to filter long customer lists by date of birth in forms and combo boxes. We will learn how to limit results to make it easier to find specific patients in a database, using non-programming methods.

Owen from Sugar Land, Texas (a Silver Member) asks: When I go to my doctor's office, they ask for my date of birth first. I assume that's to shorten the list of patients in their database so that when they ask for my name, I'm on a much shorter list. I have the same situation with my database (patient records). Since I always have their DOB, how can I limit the results so my combo boxes aren't filled with thousands of patients?

Members

There is no extended cut, but here is the database download:

•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Blank Template
• Value From a Form
• Alias
• Query Criteria

Links

• ISO Date Format
• IIF Function
• Null

Recommended Courses

• Access Expert 1

Up Next

• Filter By DOB, Part 2

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, filtering customer list by date of birth in Access, date of birth filter Access, Access combo box filter, query by DOB Access, Access forms DOB filter, limit combo box results Access, Microsoft Access patient records, Access database date of birth query, without VBA Access filtering, non-programming Access tutorial, Access query design filter date