so basically ive got the following piece of SQL:

"SELECT Scales.[Scale Name], Scales.[Root Note], Scales.Notes from Scales where (InStr(Scales.Notes, Text1.Text)"

where text1 is a textbox on the form, yet it doesnt seem to register it, is there some special way to put text1.text into the InStr function?