I have a cross tab query that works (Access 2003). It is run from a table that will have thousands of record. I have the query run off a form that has combo boxes to insert criteria into the query. When I run the query with these criteria there is an error that is basically a combo box is not a correct field for the cross tab query. I have solved this in a very inelegant way by creating a table that contains the records from the query, the macro deletes all the records in the table, and then adds the new records and finally runs the cross tab query. I have tried just putting in the values as text in the criteria and it works. Any ideas?