>thx for reply first~
>but can u more specifiy on which grid properties can control it.
>and also where should i put it on , after i specifiy the recordsource or before or others?!
>THX~

In the property sheet for your grid, make the RecordSourceType = 4 [SQL Statement]. Your SQL code would go in the RecordSource property:

select tablea.*, tableb.* from tablea join tableb on tablea.ab1 = tableb.ab1 where tablea.ab1 = 'one' order by a2 into cursor crsResults

The name of the cursor can be whatever you want.