I have a form based on two tables. I'll call them Table1 and Table2. It is a Form/SubForm form format with Table1 as the main Form and Table2 as the SubForm. What I want to do is have an unbound control on the main Form that is populated based on a query that "grabs" a value from the SubForm and uses it as a restriction in the query. Here is the SQL from the Row Source property for the unbound control on the main Form.
(where "Control1" is the name of the control on the subform containing the value I want the query to "grab")
Is there a particular syntax used when specifying to get a value off another form other than just naming that other form as I have done above? Also, does it matter than the relationship is a one-to-many (table1 can have many related records in table2, but not vice versa) - however, when there are many related records in table2, the "Control1" value for every record is identical?
Thanks for any help/direction.