Form Filter Question

[anunat]

I have a form that has four combo boxes

FromMonth, FromYear, ToMonth, ToYear

I have a dropdown list for each of them. I am doing it this way, because the data comes in once every month. So only month and year are relevant.

I use the following code to convert them to date format:

fromdate = DateValue(Me.Frommonth & "/" & "01/" & Me.Fromyear)

todate = DateValue(Me.Tomonth & "/" & "01/" & Me.Toyear)

My table has a date field. I would like to run a query from the above form for all dates between fromdate and todate.

How do I do this?​