Self-updating recordsets

[sdpsc]

I'm writing a VB program for my company that deals with their phone lists. It searches through the list and creates a recordset based on the entered criteria. It then allows the user to edit the records. If a record is edited to the point where it no longer matches the search criteria, VB removes it from the record set. How do I stop that from happening? Thanks!

 

[shakespeare5677]

I'm assuming that you are using an ado control along with a datagrid. I'm also assuming that you are filtering records selected by using the filter property of the ado control. By these assumptions I would suggest requerying instead of filtering. Just change the selection criteria and you'll accomplish the same results as filtering, only the records will not dissapear if you change the record beyond the filter(now selection) criteria.
-Max

 

[sdpsc]

Thanks for your reply! However, I should have said this earlier, my bad; I'm using RDO to open up a FoxPro DBF. How would I do it with that?

 

[shakespeare5677]

To say the truth, I've never worked with either. However, it sounds like you are applying a filter in order to show only specific records in the grid. If that is the case, isntead of filtering the records, just get another set of records only matching your desired criteria. This way, there will be no filter to hide newly changed records (I hope).
-Max