I am trying to sort from my combo box to a field named StartDate in my
form.
Trying to filter to a particular date. However I get the following
error
message Data mismatch in Criteria. Tthen when I debug the Me.Filiteron
=True
is highlighted. I figure it has something to do with expecting String
data
but is getting date data instead. Any help would be appreciated
Here is the code I am using
Private Sub FilterComboBox_Click()
Me.Filter = "[StartDate] = """ & Me.ComboStartDT & """"
Me.FilterOn = True
End Sub
Thanks
Andy
