>I havve a grid on a pageframe. The recordsource type is SQL. The recordsource is:
>
>"select Partno, Desc, QRec, QSold from Inven where Partno = thisform.currpart into cursor temp"
>
>This works great as I navigate through the partno's.
>
>If I change the recordsource to:
>
>"select Partno, Desc, (QRec - QSold) from Inven where Partno = thisform.currpart into cursor temp"
>
>I only get a single row in the grid for the first partno.
>
>Is there a restriction I don't know about?
>
>TIA- Swen
When you run Select ... where Partno = thisform.currpart, obviously you should get records for this particualr Partno (one?). So, actually second example works properly. You can always check how many records you got by =RECCOUNT("temp")
Edward Pikman
Independent Consultant