Why does this work:
Set db = CurrentDb
sSql = "SELECT Ingredients FROM Cajun WHERE RecipeID = 10;"
Set rs = db.OpenRecordset(sSql)
and this doesn't Too Few Parameters Expected 1 3061
Set db = CurrentDb
sSql = "SELECT Ingredients FROM Cajun WHERE RecipeName = [Cajun Spice];"...