Filter using Combo Box's

[Sharon Hague]

Hi All

I have a form which logs all our employees holidays/sick ect. This is ran from a query.

In this form I have a date field called MyDate & MyYear which is calculated from MyDate in my query.

Is it possible to create a filter on my form by using combo box's rather than option groups?

I want to be able to first choose the Year and it perform the filter and then choose the month in that year and perform the next filter.

I'd appreciate anybody's help on this.

Regards

Sharon

:

 

[Sharon Hague]

Can anybody help at all with the above - I am still struggling?

 

[Sharon Hague]

Hi All

I have now managed to create 2 combo box's to filter data in my report.

The first combo box (FilterOptionsYear) is to choose the year and has 3 options to choose from in its row source which are 2003, 2004 & 2005. The second combo box (FilterOptionsMonth) is to choose the month which has 12 options to choose from, from month 1 to 12

Both of these combo box's filter the data, however I can't get the combo box's to work together.

I have tried different ways in my coding but still can't get them to work together.

I want to be able to first choose the year and it to perform the filter and then choose the month and it to filter the data in that year I have chosen.

Can anybody help me with this?