Parameters

[kmrowlan]

I am getting an message that says "Too few parameters, Expected 2 when I run the following expression.

Advise on what it is looking for that I am not supplying?

strColorTemp = "Special Color"
Set rst1 = dbs.OpenRecordset("SELECT Color.*, IIf([Color].[Color]=[" & strf1Color & "],[" & strf1Color & "],[" & strColorTemp & "]) AS Expr1 " & _
"FROM Color;")
strf1Colora = rst1![Expr1]

Thanks

 

[psycoperl]

It looks as if you may not have closed one of your Quote marks. I would check there. \

OR

It looks like you are using DAO (I am not familar with it but found this in my book):

FROM: Pages 1512/1513 of Microsoft Access 2010 Bible by Michael R Groh:
Set RecordSetObject = DatabaseObject.OpenRecordset(source,
[type], [options], [lockoptions])
RecordSetObject is a variable you have declared as DAO.Recordset, and DatabaseObject is a variable you have declared as DAO.Database

So you seem to be missing the Recordset Type.