I don't know if this really belongs in the Database forum, but seeing as its using old tech (VB6 & SQL 2000), here goes...

I need to connect to a SQL 2000 database hosted on a server on our corporate network, preferabbly using a DSN connection. From this database, I need to pull customer address details (query below) based on whatever was entered into the txtQuery textbox when the user clicks the cmdSubmit Command Button.

The results of this query then need to output to list box lstSearch.

Query:
Code:
SELECT title, initials, full_name, company_name, house, address, city, county, postcode, 
customer FROM cust WHERE customer = **CONTENTS FROM TXTQUERY TEXTBOX**
All help appreciated!