query runs but cant export to excel-says because multivalue field but none in table

[tagteam]

I have a basic query that pulls data from two tables and NEITHER of them has any multi-valued fields, which i never use. The criteria comes from a dropdown box on another form which I do all the time. I can run the query but when I try to export it to excel i get:



Can't reference a table with a multi-valued field using an IN clause that refers to another database.

1. if someone added a multi-valued field without telling me what is the easiest way to find it.
2. If they did not , what is causing this error?

As you can see it is a simple query. Only a two tables and a few fields.

SELECT AllRailcarData.CarInitials, AllRailcarData.CarNumber, AllRailcarData.FormerCarInitials, AllRailcarData.FormerCarNumber, AllRailcarData.Completed, tbl_Customers.CustomerNameFROM tbl_Customers RIGHT JOIN AllRailcarData ON tbl_Customers.CustomerIDNumber = AllRailcarData.CustomerID
WHERE (((AllRailcarData.Completed)=[Forms]![f_Karen]![AcqGroup]));

[tagteam]

Update - If I remove the parameter for the Completed field which is [Forms]![f_Karen]![AcqGroup] then it will run all the cars but will also allow it to export to excel properly.

[tagteam]

Update - It even works if I copy one of the values from the dropdown box and put it in the query criteria section. Why would this dropdown be causing problems? I do reports like this all the time.