>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 :
with this
lcMyLongSQL = 'select ... '+;
' from ... '+;
' where ...'+;
' ... into cursor crsGrid'
.RecordSourceType = 4
.RecordSource = lcMyLongSQL
endwith
Cetin