Access question

[zpo]

I have setup a form with a subform with a tab folder. On one tab it references information found in table1 and on the other tab it reference both table1 and table2. Since the forms main control in set to the control source = table1, I am have trouble with getting information from table 2 (Name# errors).
When I tried to use the expression builder to change the control source for the text box

(table2)!(xxxxxx)

I get a Name# error.

How do I fix the problem and get the value posted in the box?

 

[smoker1]

Why not create a query from table 1 and table 2? Then use that query as your control source for the form.