Select A Date as a Filter (1 Viewer)

[jleval]

I have a several combo boxes that are being used as filters.
I have one for part number that goes like this in the after update event:

Me.ToolMeasurementCutterToolMeasurement_Subform.Form.Filter = "PartNumber='" & cboPartNumberTest.Value & "' "
Me.ToolMeasurementCutterToolMeasurement_Subform.Form.FilterOn = True

The one I want for a date is like this:

Me.ToolMeasurementCutterToolMeasurement_Subform.Form.Filter = "TestDate='" & cboTestDate.Value & "' "
Me.ToolMeasurementCutterToolMeasurement_Subform.Form.FilterOn = True

However, this is not working. I am getting an error that says
"The Search Key was not found in any record"

How would I set the filter to select records based on a certain date? Am I doing something wrong here?

 

[John Big Booty]

Dates need to be enclosed by the hash sign (#), Try;

Me.ToolMeasurementCutterToolMeasurement_Subform.Form.Filter = "TestDate=#" & cboTestDate.Value & "# "
Me.ToolMeasurementCutterToolMeasurement_Subform.Form.FilterOn = True