DAO table names

[joey o.]

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

[Serge]

In Access you cannot open tables from 2 different databases, unles in your example it is 1 database and 2 tables. If yes, then your SQL statement looks ok. The only thing that you have to check is to see if the corresponding tables have common values in IdNum field.

Regards,

[joey o.]

Yes, it's one Access Database. I'm trying to enter new information into ResultInfo table(currently very empty)based on selections from RuleInfo table (very full). I have a bunch of rules and if they pass or fail test,I want results to enter into ResultInfo table.I get err 438 (object doesn't support this property or method) on:
Text1 = rs.RuleInfo.RuleNum
Thanks for you patients Serge,
Joey O