2001 error, 'You canceled the previous operation

[schiu1010]

I am very confused for this error. I was just try to put a dynamic filter on a query. The error comes after I did this:

33    me.filter = " [par_year] = '2005' "
34    me.filterOn =  (me.filter > "")

Error on line 34. Any hints on this bug. (I tried another program sample and that works fine).. Dont' know if I have some setting wrong. Thanks

chiu1010

[missinglinq]

You have inadvertently posted your question in the Articles section rather than in the Forum section of our site, so I have moved it across to the Forum for you.

Welcome to TheScripts!

Linq ;0)>

[JKing]

The filterOn Property excepts the values true and false I believe.

Try Me.filterOn = True

[NeoPa]

The filterOn Property excepts the values true and false I believe.

Try Me.filterOn = True

That's not a problem JK. It accepts a Boolean value. True & False are both boolean values but it will accept any expression which resolves to a boolean (which the OP's code should do happily).

[NeoPa]

I am very confused for this error. I was just try to put a dynamic filter on a query. The error comes after I did this:

33    me.filter = " [par_year] = '2005' "
34    me.filterOn =  (me.filter > "")

Error on line 34. Any hints on this bug. (I tried another program sample and that works fine).. Dont' know if I have some setting wrong. Thanks

chiu1010

I'm afraid that, as it is clear that this portion of code has not been Copy/Pasted in, it is not something we can rely on. I appreciate that your intention was probably to keep it brief, but you must nevertheless copy/paste it in, otherwise it's almost useless to work from I'm afraid.
Certainly I can see nothing wrong with the code as posted, although I doubt the actual code will be the cause as such.