[RESOLVED] Searching for compound names in a access db file?

[Justin M]

Hey guys I ws wondering. I have a database made in access 2000 that is called compound names.

i use it in a program where the user enters a compound like FeO2 or something in text1 and press the search button. i would like it so it would search the database to look for the compound in text1 and if there is a match then put the compound name which is in the column debside the first colum that has compounds and put it in text2.

If there is not a match found then have text2 say no matches found.

I can use this code right?

Dim con As ADODB.Connection
Dim strSQL As String
Dim strCol As String
Set con = New ADODB.Connection
con.CursorLocation = adUseClient
con.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.path & "\compoundname.mdb;" & "Jet OLEDB:Database Password=****;"
strSQL = "SELECT * FROM table1"
strCol = "compound"
Call FillCombo(List2, con, strSQL, strCol)
con.Close
Set con = Nothing

but see this code originally was for another prog i had, but i dont want it search using what is in list 2, i would like it to use text1

Can you hook a brotha up? Thanks alot!!!!!