Frank,

I can get past the error now, but when selecting 'Next' or any of the sorting column names, the SQL command is dropping valiables I have passed to the sql statement previously. ie:

Existing statement ..
Where PF.ACT_DATE >= " & Span & " And PF.SYM_NAME = '" & Sym1 & "'

But after selecting NEXT or a column sort the SQL reads:
Where PF.ACT_DATE >= And PF.SYM_NAME =

As in the variables Span and Sym1 have been reset to nulls or something.