I have a situation where I need to refresh data in a listbox based on the current state of data within a local view. The view gets data from a table via odbc and I have a set filter to before I requery it first time.

The changes made to the view/cursor do not update the main data table. Trouble is any attemp to refresh the listbox ultimately fires a requery against the source table which is what I don't want. I want to requery / refresh data already in the view so I can filter out some records or drop them back in depending on some filter criteria.

Hope you get the picture.

Any ideas?

Thank you.


Mathias