I want my query to work for any one of my search forms. Im using 2 variables on my forms to tell the query which column to search by, and where to get the user defined criteria from. theField, and theCriteria
SELECT [itemid], [lastmodified], [accession], [name], [description]
FROM item
WHERE...