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)