How do I reference a user input control on a sub form in a second control's Row Source SELECT statement?
What I have:
SELECT Table1.Field1 FROM Table1 WHERE Table1.Field2=Me!SubForm1.form!Control1;
is not working as expected. The resulting list uses the Control1 value from the static form, not the currently entered value in Control1.