>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

You can get around this by settingthe recordsource to a cursor, and create that cursor with your SQL in the form.load:

SELECT * FROM MyTable INTO CURSOR MyCursor