Sorry, I'm being really dim here.
My default recordset, rswhatever is "select field1, field2 etc from tablename"
the querystring created by the dataassist wizard, (called setQueryBuilderSource) appends the where clause onto the SQL select statement.
Don't I then need to append the LIMIT 500 onto the end of this statement before it is processed ?