You canceled the previous operation !

[JeffT]

Hi, I've been progamming Access for a couple of years so am not a complete novice but I can't seem to work out this problem.
I downloaded some code from "databasedev.co.uk" from the query section called "Using a Microsoft Access listbox to pass criteria to a query". It works fine. However when I import my own table and change the code to SELECT the imported table and change the WHERE statement to my new string within that table , I get an error. When I select from the list box and click the command button I get the message "You canceled the previous operation".
However if I select the "ALL" selection from the list box it does return all the records.

Any help would be gratefully received!

JeffT

 

[TastyWheat]

Since it was so long ago you probably fixed the problem, but in case someone else has the same problem (and I have recently) here's my two cents.

The error can sometimes be related to a corrupt database object. I know nothing about dealing with corrupt objects so do a different search for that.

The error can also occur when you refer to a non-existant field or table (misspell something) or it can happen if you have mismatched data types.