Too few parameters, expeced 1.

[Peter Bellamy]

I am getting this error on a simple SQL statement

StrSql = "SELECT * FROM Equipment WHERE [equip_index] = Me.[calls_equip_sno]"
Set StrDb = CurrentDb()
Set StrRst = StrDb.OpenRecordset(StrSql)

both [equip_index] and Me.[calls_equip_sno] are Long Integers

Where am I going wrong?

 

[the_net_2.0]

peter,

numeric values in an sql string have to be concatenated out...

where [equip_index] = " & me.[calls_equip_sno]

also, if your fields have no space, brackets are not necessary.

HTH

 

[Peter Bellamy]

Thanks, that fixed it!

pnb