In an inventory programme I have a form with a grid which has a cursor created through SQL as it's rowsource. The cursor contains the balance stock of a selected product, and is created at the selection instance of the product, by subtracting the issues from the receipts. Now, every time a product is selected, the cursor has to be refreshed or recreated, taking into consideration the new issue.

Every time I do this, my grid turns blank and vacant. As a result I have to go out of the form to do every issue through a new form , and then reload my 'balance-stock' form so that it takes all the new parameters from the table during the load event.

Any suggestions as to how I can refresh a cursor while a form is active, without allowing my grid to go blank, or, simply, is there a better way for me to do the above operation ?

Thanks,

With best regards,

Steve.