me.filter not working

[wrweaver]

I have a bound continuous form that has a form filter on load that filters the control workerid that is set to "WorkerID = 2." I want to have a button that filters another control (StartTime) by today's date while still maintaining the initial filter. I thought the code would be

me.filter = "StartTime=" & Date
 me.filteron = true

BUT when I run the code it makes all the records disappear. Is this the wrong code?

 

[pbaldy]

Does the StartTime field include the time? If so, only midnight would match the date alone.

 

[wrweaver]

Yeah the date and time are stored with format mm/dd/yy hh:nn am/pm

 

[wrweaver]

Does that mean there's no way to filter it?

 

[pbaldy]

Try

me.filter = "DateValue(StartTime)=#" & Date & "#"

 

[StarGrabber]

Me.Filter = "StartTime=" & mdlUtilities.ISODate(Date)

 

[wrweaver]

Thanks that worked perfectly but how would I enter that as criteria in a query?

 

[pbaldy]

Which answer are you referring to (I think I know)? And why would it need to be a criteria?

 

[wrweaver]

I was referring to your answer and nevermind youre right. I can just use the filter in the form instead of including it in a query.