>Sorry all, forget to mention that I can't put it into the Select because of the 255 char's restriction in the recordsource property.
>
>Kev

Kevin,
But you can :) Just do not use PEM sheet :

*grid.init
with this
 lcMyLongSQL = 'select ... '+;
       ' from ... '+;
       ' where ...'+;
       ' ... into cursor crsGrid'
 .RecordSourceType = 4
 .RecordSource = lcMyLongSQL
endwith

Cetin