Hello
I am having a hard time setting multiple filters to my main form
the following went just fine :
Now i am trying to add a filter on the field datafim wich is a date/time field in the format 02/09/2021 08:02:49
it produces an error "syntax error , missing operator"
Any thoughts ?
I am having a hard time setting multiple filters to my main form
the following went just fine :
Code:
strfilter = "[distritoID] = " & Me.searchDist & " And concelhoid = " & Me.searchConc & " And freguesiaid = " & Me.searchFreg
Me.FilterOn = True
Me.Filter = strfilter
Now i am trying to add a filter on the field datafim wich is a date/time field in the format 02/09/2021 08:02:49
Code:
strfilter = strfilter & " And dataFim > " & Now()
Me.FilterOn = True
Me.Filter = strfilter
it produces an error "syntax error , missing operator"
Any thoughts ?