Question:
I’m trying to install a search facility on a database program I have written using VB6 and an Access database. I’ve opened by inserting a data control onto my form and linking it to my database, and appropriate table. This gets all the data from the table fine. How do I execute another SQL statement to refine the records into those that come back from the SQL statement?
Answer:
You can specify a SQL statement as the source for your data control. If you look up how to create a WHERE clause in SQL, that will allow you to filter your records to a smaller set.
