Refer to a subform

[Greyowlsl]

I have a query which has a field with a where statement and criteria: ([forms]![form1]![List2]), however i now have 'form1' as a subform on 'form2', what do i write in now? The explanations on the net haven't really helped.

Thanks guys.
, Leon

 

[John Big Booty]

The Criteria will be;

[Forms]![YourMainForm]![YourSubForm]![YourControl]

Book mark this page for your future reference. For this example look at the section headed Not in these forms