Oh yea, the code I posted would load what is in a column in a database file into list2,

so my problem is I need to modify the code so it searches for the compound is the first column of the compounds database file and if there is a match found between text1 and the first colum, then text2 would display what is in the other column for that row.

How would I set up a Where clause in that code?

thanks!