form versus query

[cvaccess]

Hello,

Something strange is going on with a query I have. I have a command button on a form that pulls from a query "RejectPercentTPSummary2". When I run the query through the form (command button) it brings up an error box stating "You cancelled the previous operation." But when I run the query, natively, through the Query Tab it runs fine. Why is this?

Thanks.

 

[RivetHed]

it shouldn't be anything to do with amount of data cos it's not even attempting to run the query, I think the clue may well be in the bit of the error message that says: 'a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables' you could try maybe splitting the final query into 2, but if the expression works for one of your other queries it should work for this one too.
Although you say it works for a different data type, what are the relevant data types for the 2 queries, the one that works and the one that doesn't?

 

[cvaccess]

They have the same data types but they have different tables. That is the difference. I have tried parsing the query further and still I got the same error? Anything else?

 

[RivetHed]

absolute last ditch thing here, create a new copy of the table and see if that changes anything and then I am completely out of ideas