General information
Category:
Forms & Form designer
Title:
Refreshing a grid that has a cursor as it's row source.
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.
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