Hi Everyone!
Could someone help me out with learning this?
I am using DAO. I'm using this code to open a database and select a table to work with:

Set db = OpenDatabase ("C:\db2")
' open up the dynaset
Set rs = db.OpenRecordset("TableName1", dbOpenDynaset)

This works great. Now I want to open two tables just like when using recordsource with datacontrol:

strSQL = "Select * from _ TableName1,TableName2 _
where TableName1.Id_num = Table2.Id_num"
Set db = OpenDatabase ("C:\db2")
' open up the dynaset
Set rs = db.OpenRecordset strSQL, dbOpenDynaset)

This doesn't work great

Any Code or Help is really appreciated!

Thanks Again,
Joey O