I think you may be making this harder than need be. Try creating a local, parameterized view:
create sql view RptCursor as select * from Imprn where PrintNo = ?nPrintNo
Then in your form DE, you can add this view. Set the NoDataOnLoad to
.T. and in the BeforeOpenTables, put
set talk off. In the click, put this code:
local nPrintNo
nPrintNo = thisform.txt_printno.value
requery("RptCursor")
Add whatever other code you need around this.
Mark McCasland
Midlothian, TX USA