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

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.