Hi Brent.

Are you comparing these fields day, month, year1 year2 to actual date type Fields in the database.
Please be more specific. See Rule #2.

Yes sir.

Sami, year1 and year2 are just the year, 2024 and 2025. The date in my table is  an actual date. I want to be able to enter the month and day with no year and search those months based on the years in the year1 textbox and the year2 textbox.

Personally, and it's because I like it.  Richards Search as you type video.  I have a text on a form that is named "MyDateSearchBox"

On Change Event:

Private Sub MyDateSearchBox_Change()
    'Search for Dates
    On Error GoTo MyErr:
        Me.RecordSource = "SELECT * FROM YourTableNamesTbl " & _
            "WHERE " & _
            "VideoDate LIKE ""*" & MyDateSearchBox.Text & "*""" & _
            "ORDER BY YourTableNameTbl.WhaeverID; "
    
    
exit_MyErr:
            MyDateSearchBox.SetFocus
            MyDateSearchBox.SelStart = Len(MyDateSearchBox.Text)
            
            
Exit Sub
MyErr:
MsgBox "No Matches Found, Now Resetting", vbCritical, "Error"
    MyDateSearchBox = Null
    Me.RecordSource = "Select * FROM YourTableNamesTbl"
    MyDateSearchBox.SetFocus

Exit Sub
End Sub

Thanks all! I was able to get it to work but I could not get it to work with a combo box for the month.  I just set up a text box and entered the corresponding number with the month(January =1) in a StartMonth textbox and then an EndMonth textbox.  When I tried to set up the combo box to display the month name I tried a couple of ways. I created a table with only the month and the coordinating number(January = 1). If I asked for records between January and March it would return revenue numbers for January through March but also Oct, Nov, Dec revenue numbers.  Then I tried creating a query calculating the month number and the month name and using the query to make combo boxes for start and end month and I received the same results as the other method with combo boxes. What am I missing? Thanks for any assistance.

Got it to work the way I wanted but had to use a “cheesy” method.  The SQL was apparently treating the MonthNumber field from my table as a string so the  number 1 was not being recognized as a number from the combo box. So I created a text box(made it invisible) on the Val of the combo box and it works now.  I know there is a better way but it works the way I wanted it to. Thanks all.