Search Date Range by month in a Combo Box within a Form?

[accote]

Hello, I'm trying to create a combo list box in a form that has all 12 months (January, February......etc,) listed in rows, and depending on the selection will bring up only that particular month within a range of dates from a table. I don't want it to look at the day or the year, but only the month.
Example: I select January from the drop down list in my combo box and my form will display all records with dates that are in January regardless of month or year.
Any help with this would be greatly appreciated. Thanks

[June7]

How do you want to execute the filter? Parameterized query or set form filter property in VBA?

Me.FilterOn = False
Me.Filter = "Format([Birth Date],"mmmm")='" & Me.comboboxname
Me.FilterOn = True

[ssanfu]

OK, the combo box row source would be either a table with two fields
MthNumber Integer
MthName Text

and the row source for the combo box would be
SELECT MthNumber, MthName FROM tblMonths ORDER BY MthNumber;

Set the properties of the combo box to:
Limit to List = TRUE
Column count = 2
Column Widths = 0";1"
List Rows = 13


--------------
OR

a value list (I prefer this):
;"All";1;"January";2;"February";3;"March"; .....;12;"December"

Set the properties of the combo box to:
Row source type = Value List
Column count = 2
Column Widths = 0";1"
List Rows = 13



The query for the form would be :

SELECT Employees.EmpLName, Employees.EmpDOB
FROM Employees
WHERE (((Month([empdob]))=[forms]![Form7].[cboMonth])) OR ((([forms]![form7].[cboMonth]) Is Null));

In the after update event of the combo box:

Private Sub cboMonth_AfterUpdate()
   Me.Requery
End Sub

Change the BLUE terms to your field/table/combo box names.

[accote]

Hello Steve, THANK YOU, THANK YOU and THANK YOU again, I have been messing with this for a week now, and I finally got it to work.
Your help was truly appreciated. I used the Value List with the Query & Code.

Have a wonderful Memorial Day Weekend.

Claudia

[accote]

Great forum, thank you June7 & ssanfu for your help, I got it working now