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
BUT when I run the code it makes all the records disappear. Is this the wrong code?
Code:
me.filter = "StartTime=" & Date
me.filteron = true
BUT when I run the code it makes all the records disappear. Is this the wrong code?