I am trying to apply a filter to a date field [ContactDate] on a datasheet subform based on a date field in the main form tmpDateFilter.
Both fields are date fields and there are definitely records that match the date entered on the main form. I am trying the following but although the datasheet subform does filter - it returns an empty list. Can anyone see what I have got wrong here.
.Filter = "[ContactDate] = #" & Me.TmpDateFilter & "#"
.FilterOn = True