From the information provided this is how I would set this up.
Obviously you will have different names for your fields and table/query so change as appropriate.

Oh Okay Kevin, I will try it.

This is what I had:

Public Function RequeryForm()

    Dim mySQL As String, whereStr As String

    mySQL = "SELECT * FROM HoursLogT "
    whereStr = ""
    
    If Not IsNull(CboDateFilter) Then
        Select Case CboDateFilter
            Case "Today"
                whereStr = "LogHourDate=#" & Date & "# "
                StartDate.Visible = False
                EndDate.Visible = False
                StartDate = Date
                EndDate = Date
            Case "Last 7 Days"
                whereStr = "LogHourDate>=#" & Date - 7 & "# And LogHourDate<=#" & Date & "# "
                StartDate.Visible = False
                EndDate.Visible = False
                StartDate = Date
                StartDate = Date - 7
                EndDate = Date
            Case "Last 14 Days"
                whereStr = "LogHourDate>=#" & Date - 14 & "# And LogHourDate<=#" & Date & "# "
                StartDate.Visible = False
                EndDate.Visible = False
                StartDate = Date
                StartDate = Date - 14
                EndDate = Date
            Case "Last 30 Days"
                whereStr = "LogHourDate>=#" & Date - 30 & "# And LogHourDate<=#" & Date & "# "
                StartDate.Visible = False
                EndDate.Visible = False
                StartDate = Date
                StartDate = Date - 30
                EndDate = Date
            Case "Last 60 Days"
                whereStr = "LogHourDate>=#" & Date - 60 & "# And LogHourDate<=#" & Date & "# "
                StartDate.Visible = False
                EndDate.Visible = False
                StartDate = Date
                StartDate = Date - 60
                EndDate = Date
            Case "Last 90 Days"
                whereStr = "LogHourDate>=#" & Date - 90 & "# And LogHourDate<=#" & Date & "# "
                StartDate.Visible = False
                EndDate.Visible = False
                StartDate = Date
                StartDate = Date - 90
                EndDate = Date
            Case "Last Month"
                whereStr = "Month(LogHourDate)=#" & Date - 30 & "# "
                StartDate.Visible = False
                EndDate.Visible = False
                StartDate = Date
                StartDate = Month(Date) - 30
                EndDate = Month(Date) + 30
            Case "This Month"
                whereStr = "Month(LogHourDate)=#" & Date & "# "
                StartDate.Visible = False
                EndDate.Visible = False
                StartDate = Date
                StartDate = Month(Date)
                EndDate = Month(Date) + 30
             Case "Custom Date Range"
                whereStr = StartDate And EndDate
                StartDate.Visible = True
                EndDate.Visible = True
        End Select
    End If
    
    If whereStr <> "" Then whereStr = " WHERE " & whereStr
    
    mySQL = mySQL & whereStr
    mySQL = mySQL & "ORDER BY LogHourDate"
    RecordSource = mySQL
    
End Function

Here's also the Form Setup:

Made some changes based on the additional data.
I added a couple of buttons for This Month & Last Month which show when 'Custom' is selected which will automatically add the StartDate and the EndDate, then requery the form.

I would actually blank out both text boxes when the Combo Box is updated

Add this to the start of the After Update event.
StartDate = ""
EndDate = ""

Hey Kelvin, when using Multi-Subform, in the Form's On-Load. Should I put the "RequeryForm" function in each Subform and make it an Public Function to Filter the Subform's Data?

Also, we are not using Buttons for the "Last Month" and "This Month". They are in the "CboDateFilter" Combo Box fields.

OK. Here is the revised code I came up with so all the filters come from the combo box (no buttons needed).

Note: I did this for a continuous form (no subforms) so you will have to modify the code for your specific needs. It should be enough to get you started.

If I wanted to Filter the Subforms, I will have the Call th "Requery" Sub in the "Open Load" in each Form.

If the subforms are set up correctly, when the one with the date field filters the other 2 should also filter based on there respective IDs.

Thanks Kevin, I got it. I had to "FormName.Form.RecordSource = mySQL" for each Form.

Kelvin, the Code is working Correctly... Thanks again, but I keep going this: