Friends,
Haven't seen a similar post yet, so here goes. I have a typical QBF search form which returns criteria matches in a continuous subform (fsubSearchResults) at the bottom of my main form. Oftentimes I want to isolate (or remove) certain records returned in the results subform. I don't want the records to be removed from the database, rather I just want to take them out (or hide) them from the search results recordset.
I'm sure someone will just say to further filter the recordset, but that is not what I need to do here. The returned records match all of the search criteria fine, but not all of the record data is equally reliable, since it comes from various sources. So, some records, while they may match the search criteria, may not be the best data. I would like to be able to hide or remove them from the search results recordset.
I was thinking that I could put a radial button on the subform that when clicked would hide that specific record in the recordset. I tried to put this simple code in the AfterUpdate event of the radial button:
This, of course, does not work as it hides all records. Is there another way to write this code or does anyone have any idea that would give me the same basic result that I'm looking for? Hopefully I've explained myself clearly. Thanks for any ideas, feedback.
-Lou
Haven't seen a similar post yet, so here goes. I have a typical QBF search form which returns criteria matches in a continuous subform (fsubSearchResults) at the bottom of my main form. Oftentimes I want to isolate (or remove) certain records returned in the results subform. I don't want the records to be removed from the database, rather I just want to take them out (or hide) them from the search results recordset.
I'm sure someone will just say to further filter the recordset, but that is not what I need to do here. The returned records match all of the search criteria fine, but not all of the record data is equally reliable, since it comes from various sources. So, some records, while they may match the search criteria, may not be the best data. I would like to be able to hide or remove them from the search results recordset.
I was thinking that I could put a radial button on the subform that when clicked would hide that specific record in the recordset. I tried to put this simple code in the AfterUpdate event of the radial button:
Code:
me.detail.visible = falseThis, of course, does not work as it hides all records. Is there another way to write this code or does anyone have any idea that would give me the same basic result that I'm looking for? Hopefully I've explained myself clearly. Thanks for any ideas, feedback.
-Lou
