Yes, that works fine when I use a select  statement based on a table.
What I'd like to do is use a stored  proc that has no criteria then
use a dynamically generated where clause. I can do this in Access
but can't get it to work with SQL Server. Something like:

strSQL = "SELECT * FROM MyStoredProc WHERE (tblPerson.State = " &"'"&
cboState.value &"')"