Surge or Anyone on RecordSets

[joey o.]

This generated a "too few parameters(expected 2)" error.
What can I do to make it go away and work good using DAO?

strSQL = "Select * from TableName1 Inner Join TableName2 On" & _
TableName1.Id_num = Table2.Id_num"
Set db = OpenDatabase("C:\db2")
Set tb = db.OpenRecordset(strSQL, dbOpenDynaset)

[Serge]

It means that you either you misspelled your field (or Table) name. Check your select statment again to see if that's the case.

[joey o.]

Thanks Serge,
Spleling is not my strongest point! I thank you again.