>>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
>
>Mathias, what is the RecordSourseType you use in the listbox? Alias?
>I did not test that, but may be you can try type 3-SQL Statement, and do SELECT from your view using the same criteria for WHERE as it is in your FILTER for the view.
>
>Nick
Thanks Nick. I haven't tried it yet but logically I don't see why it shouldn't work. The recordsourcetype was (yes you guessed right) Alias.
Thanks
Mathias Banda
Time is longer than a rope.