Being a slow-witted newbie, I have been painfully attempting to string together my first app, and thanks especially to the ubiquitous Preeti and the web-based tutorials of Dale Shaw and Karl Moore it has been coming along nicely. However, I have some problems with syntax and I am pretty clueless. I think I'm at the point where I know what I'm doing and I just don't know exactly how to express it. If anybody could tell me what's wrong with the following code, I'd appreciate it.

TIA,
Jonathan

SQL$ = "SELECT * FROM " & strTable
SQL$ = SQL$ & " WHERE " & strFindBy
SQL$ = SQL$ & " = " & strMatchWith
SearchSQL = SQL$
Dim db As Database
Set db = OpenDatabase(There is a database directory here, but for company security reasons I can't post it)
Set Adodc1.Recordset = db.OpenRecordset(SearchSQL)
MSHFlexGrid1.Visible = True
End Sub

------------------
"Black?"
"For over thirty years."