To clarify - thisform.currpartno is set from a PARTNUMBER table that is not related to the Inven table. Here's the setup

INVEN
vendor c(15)
partno c(15) non-unique
qrec n(4)
qsold n(4)

PARTNO
partno c(15)
[misc data]

As I navigate the PARTNO table, I want my grid to display the onhand from each vendor which is (qrec - qsold). The first select willshow me the INVEN records for each partno but the second select will not.

-Swen
PS Thanks for a quick respond!