Me.filter with datepart from 2 combo boxes?

[wackywoo105]

Please help

This works:

Me.Filter = "DatePart(""m"", [due date])
=" & Me.Combo382



This also works (but obviously sets the dates to
match march 2014):

Me.Filter = "DatePart(""m"", [due date]) = 3 And
DatePart(""yyyy"", [due date]) = 2014"

This however does not
work:

Me.Filter = "DatePart(""m"", [due date]) = & Me.Combo378 and
"DatePart(""yyyy"", [due date]) = & Me.Combo380

Where am I going
wrong?

[June7]

Right idea to concatenate variable but missing quote marks.

Me.Filter = "Month([due date]) = " & Me.Combo378 & " And Year([due date]) = " & Me.Combo380

[wackywoo105]

Thank you very much. That worked a treat. Is there a thanks button? I did the reputation thing.

[June7]

The rep thing is the thanks. Glad it worked.