Continuous Form and a Combo Box Filter

[brew]

Hi,



I don't suppose I could ask what is probably a rather basic question, either way it has me stumped.

I have a continuous form with the following fields

Case No -- Completion Date -- Cost 1 -- Cost 2 -- and a few more

The field I'm interested in filtering the form by is the 'Completion Date' field.

I would like to have two combo boxes, one to filter by month and another to filter by year.

My first problem is how to populate the combo boxes based on the data that's available, the month combo box can quite happily have and the months of the year, but the year combo box should only show available years since I don't think it's ideal to have to pick from every year past, present and future.

Then there's the matter of filtering the data.

Thanks in advance for any help

[brew]

Right, I think I may of made a little progress but i'm having some trouble wrapping the various parts up with a nice bow.

Correct me if I'm wrong.....

I have two Combo boxes;

[CboMonth]

Row Source: "January";01;"February";02;"March";03;"April";04;" May";05;"June";06;"July";07;"August";08;"September ";09;"October";10;"November";11;"December";12

Bound Column: 2
----------------------------------

[CboYear]

Not too sure how to go about the year combo box, is there a way of populating the combo box with available years or am i stuck with manually entering years as with [CboMonth].
---------------------------------

As for running the filter i believe i can use this

Private Sub CboMonth_AfterUpdate()
Me.Filter = "Month(CompletionDate)=" & Me.CboMonth & "AND Year(CompletionDate)=" & Me.CboYear

Private Sub CboYear_AfterUpdate()
Me.Filter = "Month(CompletionDate)=" & Me.CboMonth & "AND Year(CompletionDate)=" & Me.CboYear
End Sub

---------------------------------

I think I have all the parts right but as my Access knowledge isn't great I'm having trouble bringing everything together, if someone wouldn't mind helping me stick these fragment together id be very grateful.