General information
Category:
Forms & Form designer
Title:
Select...into cursor used in grid
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only