Display results on a form based on date range

[lehi53]

I have a form that I want to display certain results.



I have a drop down list that can select who I want to see too. And a form that displays the record and other information of the person that is selected in that drop down box. I also have a next record or previous record button that will go to different records.

I need the ability to display who is in the drop down list based on a date range criteria, and who the form sorts through to display only the people whose expiration date fall in between a specific date range. And I want to only sort through those people and be able to change the date criteria.

I attached my database for you to look at. I am a beginner so any help you can give would be huge.

[June7]

What date range criteria? Where is this criteria input?

[lehi53]

The date criteria would be various. It could be show me everyone in the current month, in the upcoming month, the next two weeks, those with an expiration date within a specific range (march 1 to March 14). The data pull from the expiration date.

What date range criteria? Where is this criteria input?

[June7]

Need to input the date range criteria somewhere, such as two textboxes on the form. Then the combobox RowSource could refer to the textboxes as filter parameters. That will allow you to select a specific individual to filter the form on. However, if you want to sort the form for multiple persons within the date range, that means applying the date range criteria to the form's filter.