I want to make 2 drop down list for a date range in my form? 1

[KaayJaay]

How do i make 2 drop down lists that are related and then a button that when clicked takes both, applies them to a query and spits out the result. ex. i am using the start date and end date and i want the query to find everything in between.

Thanx
KaayJaay

 

[THWatson]

KaayJaay
I will call your form frmSelectDates, your drop down lists ListStartDate and ListEndDate. Change the names to suit your form and list names.

In your query where you have the date field, enter criteria which would be like the following...
Between Forms!frmSelectDates!ListStartDate And Forms!frmSelectDates!ListEndDate

Hope that helps.

Tom