Filtering by date

[radek225]

I filter my subform (datasheet) by fields, everything works great except "date" column. MS Access shows that record does not exist but it isn't true.

My code

Me![frmAktPD].Form.Filter = "[Data przyjęcia] = " & Me.DataPrzyjecia
        Me![frmAktPD].Form.FilterOn = True

Where is the problem?

 

[AOB]

Try adding '#' boundaries to the date :

Me![frmAktPD].Form.Filter = "[Data przyjęcia] = [COLOR=red]#[/COLOR]" & Me.DataPrzyjecia [COLOR=red]& "#"[/COLOR]
Me![frmAktPD].Form.FilterOn = True

Also, make sure that the value of Me.DataPrzyjecia is appropriate for querying (i.e. in mm/dd/yyyy format) :

Me![frmAktPD].Form.Filter = "[Data przyjęcia] = #" & [COLOR=red]Format(Me.DataPrzyjecia,"mm/dd/yyyy")[/COLOR] & "#"
Me![frmAktPD].Form.FilterOn = True