Have to do what the error instructs.
What is the form RecordSource - query? Post the query for analysis.
Simplify the query then build it back up in stages until you hit the failure again.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.