FredGarvin
Mechanical
- Oct 10, 2001
- 221
I am writing a, what was supposed to be, quick and dirty DB interface in VB6 using the ADO. Everything is fine, but I want to add some functionality and I am not quite sure how to do it. I am most likely not seeing the forrest for the trees.
I have a form that I have tab control on (with multiple tabs). Each tab, in theory, will represent a different query on the same DB. What I was hoping to do is to use one ADO object on the form and have each tab display it's own query results (say in a data grid).
Do I need to create a new recordset for each query or is there a way that I can just filter the main recordset to display just what I want?
Thanks for any input.
I have a form that I have tab control on (with multiple tabs). Each tab, in theory, will represent a different query on the same DB. What I was hoping to do is to use one ADO object on the form and have each tab display it's own query results (say in a data grid).
Do I need to create a new recordset for each query or is there a way that I can just filter the main recordset to display just what I want?
Thanks for any input.