>If SQL is static (not changing on the fly) easiest is to put SQL directly to >grid.recordsource and set recordsourcetype = SQL. It seems you set >recordsourcetype = alias and the alias is the one you're selecting into.


Hi,

Thanks for your suggestions. I've tried putting the SQL statement
into grid.recordsource & also set the recordsourcetype to SQL. I'm
still not getting anything, what i suspect is that the grid is being
initialized at the very begining & thus not registering my search
criteria or rather the SQL statement in the grid.

Just for your info a sample of my sql statement. Take note of the WHERE clause
eg:
Select cds.ncode, songs.csgname from cds inner join songs on
cds.ncode=songs.ncode WHERE songs.csgname =
alltrim(thisformset.form2.key.value) order by songs.csgname


Thanks

Andrew Kong