Hi everyone!
I'm trying to do the DAO database thing and it's been a battle. I'm using this code to try to open two databases and so far it hasn't hic-uped so I guess this is good.What I don't know is how to refer to the table names.

strSQL = "db.OpenRecordset(SELECT ResultInfo.*, RuleInfo.IdNum" & _
" FROM RuleInfo INNER JOIN ResultInfo ON RuleInfo.IdNum = ResultInfo.IdNum;" & _
", dbOpenDynaset)"
Set rs = strSQL

'This only works with one table(when the rs is 1 table):
rs.addItem
text1 = rs!TableItem1
text2 = rs!TableItem2
rs.Update

'I want to do this:
rs.addItem
text1 = rs.ResultInfo.TableItem1
text2 = rs.RuleInfo.TableItem1
rs.Update

Any hints, codes, or syntax suggestions? This is driving me nuts.

Thanks Again,
Joey O