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?

[June7]

The query can reference the boxes as input parameters.

Where do you have the fromdate and todate calculations - in textbox ControlSource?

SELECT * FROM tablename WHERE datefield BETWEEN DateValue(Forms.formname.Frommonth & "/01/" & Forms.formname.Fromyear) AND DateValue(Forms.formname.Tomonth & "/01/" & Forms.formname.Toyear);

[anunat]

I was not sure where to put the fromdate and fromyear calculations actually. Can you please explain how to do that?

[anunat]

I put the calculation in the controlsource and tried this. It worked. Thank You Thank You Thank You