Too Few Parameters Expected 1 Error 3061

[CatFish]

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];"
    Set rs = db.OpenRecordset(sSql)

 

[RuralGuy]

Try:
sSql = "SELECT Ingredients FROM Cajun WHERE RecipeName = 'Cajun Spice' ;"

 

[CatFish]

Thanks Rural Guy. I don't know why I couldn't think of that (brain freeze)

 

[RuralGuy]

I specialize in the easy questions. Thanks for the softball.