Oooh, sweet solution! I like it.

>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.