Wai Wai,

Please hit the caps lock key, all uppercase is difficult to read.

Can you please tell us what you want to see in the grid and what you do see adn what is wrong with what you get?

As a wild guess at things which are obvious to me, I would guess that SONO is a variable? Does it contain the value you think it does, you can use the debugger to check on this. I woudl also suggest using a naming convention that removes the possibility that there is aconflict with the variable's name and a field name somewhere, usually we use a two character prefix with the first char showing the scope of the variable and the seocnd showing its data type, so for a character we would name the variable lcSoNo.

Secondly, why are you selecting so_no from both tables when they are joined on that field, it will by definition of the join be the same value. You could ge teh same data using;

SELECT So_no FROM SoHead WHERE SoHead.so_on = lcSoNo INTO CURSOR RESULT

In addition you may need to call the grid's refresh after you change the RecordSource as in;

With Thisform.GRID
  .recordsourcetype = 4
  .recordsource = "SELECT So_no FROM SoHead " + ;
                  "WHERE SoHead.so_on = lcSoNo INTO CURSOR RESULT"
  .Refresh()
EndWith

Also, can you have tell us where this code resides and when you want it to execute?