I've got a really bizarre problem that's making me crazy. I've got a table that originally had a field called "Route" that was an Integer. I created a view based on this table, with a filter on a date field and on this route. Because of a design change, route became a C(5) field. I adjusted my code (and double, and triple checked all of it) so that my view parameter for the route is set to a character.

My program opens the view with the NODATA clause, sets the view parameters, then issues a =REQUERY(). It fails with a "Operator/Operand type mismatch" on the requery. If I change the view parameter back to an integer, it works OK. I've deleted the view and recreated it, removed the index on the table (based on route) and recreated it, but it still keeps failing.

Outside of my program (in the command window) if I open the database, use my view, set the view parameters, it works OK. In fact, if I set the route to an integer value it fails with the same Operator/Operand type error.

Any ideas on what the heck is happening?