Does anyone know why there is a limit in the RecordSource property, I have filled one with a large SELECT statement only to find out it had chopped the last 10 or so characters off the end!!

Any ideas on why there is a limitation anyone?

Thanks
Kev