Help on DAO

[joey o.]

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

[Thai]

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

[joey o.]

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.