Help on DAO

Hi everyone!
I'm trying to open two Access database tables. What I don't know is how to refer to the table names.
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

Here's the code:

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

What exactly are you trying to retrieve from the two tables and what are the names of the two tables? I don't get what you are trying to accomplish, I know that you want to open two tables but thats all I can figure out. Let me know what you are trying to do exactly and I should be able to help you out, if not, someone else probably can.

Thai

I'm trying to enter new information into ResultInfo table(currently empty)based on code done to fields from RuleInfo table (very full). I have a bunch of rules and if they pass or fail a coded test,I want results to enter into ResultInfo table fields.