Weird Error

[SteveCarrier]

I have a module which changes the recordsource of different forms with new sql statements. It works for most of them, but for a couple I get a weird error when it tries to assign the new sql to the recordsource:

Run Time Error '2001'
You cancelled the previous operation.

Has anyone seen this before?

Thanks.

Steve Carrier

 

[Guest_imported]

When you execute the "problem" record source queries do they return any records? If they don't, this may be causing your problem. If this is the case then you can write code to ignore the error.

 

[SteveCarrier]

Thanks Mr. KC for your prompt reply.

I actually found out that I mistakingly put quotes ('intSequence') around my integer in the sql queries. That had messed it right up!

Steve Carrier