Filter by date

[Sadukar]

Hi all,

I want to filter a subform by a date. Can someone give me a few pointers.

What I want is to filter a date in the format 01/08/03 by the month being 08.

Me.subform.Form.Filter = "[Date] = '##/08/##'"
Me.subform.Form.FilterOn = True

Any sugestions?

thanks
s.

 

[Eupher]

First, rename your date field to something other than "Date". You should not use field names that are the same as Access functions. Something like this should work:

Me!subform.Form.Filter = "Format([dtDate], 'm') = '8'"
Me!subform.Form.FilterOn = True

Ken S.

 

[Sadukar]

thanks ken

works perfect.