So whats with all the char characters?

Try something like

Dim rRecord as Recordset
SQL = "SELECT * FROM Categories WHERE Description Like '" & Text1 & "'"

-> Categories must be a recordset name and Description must be a field in that recordset.

set rRecord = General.Open(SQL)

Any Help.