Me!Filter Missing Operator - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Me!Filter Missing Operator

Stanley Mc Keown

14 months ago

My Me.filter works when it is only

Me.Filter = "[CalcWKDue]=" & DatePart("ww", Now(),1,2) & "And [Active]=" & " True.

But if I add

& "And [CalcYearDue]=" & DatePart("yyyy", Now(),1,2)

I get the missing operator error

The form is based on a query and both CalcWKDue and CalcYearDue are calculated fields made by that query.

The code for the Me.Filter is in the after update event of a toggle switch.

Can Anyone help me see what is wrong

The form data is from a Query and CalcWKDue

	Sami Shamma @Reply 14 months ago
Define a String variable and put the filter in it and mshbox the string. Make sure it is correct.

	Tom Juric @Reply 14 months ago
You might need a space between the double quotation and the word AND ----->> " And [CalcYearDue]=

	Kevin Robertson @Reply 14 months ago
The first thing I check is spacing. Caught me out so many times. LOL

Stanley Mc Keown OP @Reply

14 months ago

You chaps are on the money again. That space between the " and the And of the CalcYearDue filter was the problem but curiously there was no space between the " and the And of the Active filter but the Active filter worked whereas the Year filter didn't. So I when I saw that both had no space I put the space in both expecting the Active to not work or both not work but to my surprise both work perfectly

Thanks again fellas

	Tom Juric @Reply 14 months ago
was no space between the " and the And of the Active filter --> this is because the TRUE come IMMEDIATELY after the "=" sign. In the second part the word TRUE and the second clause runs together " & " True (ADDING) & "And [CalcYearDue]=" & DatePart("yyyy", Now(),1,2)--->>TRUEAnd [CalcYearDate]

	Stanley Mc Keown OP @Reply 14 months ago
Ah I see -- thanks again Tom

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View