Using Subform entry as criteria in a Query

[bdicarlo1]

Hi,



I have the following Form and Subform. Form name is "100-Select Form". Subform name is "103-Report Dates". Within the subform I have two fields I'm using, "Start Date" and "End Date'.

In my query I have a date field. I want the query to read from the Subform (if I open the subform directly my criteria listed below works, but when the main form is open, my query doesn't seem to be able to read from the subform).

Here is the criteria I have in the date field of my query: >=[Forms]![103-Report Dates]![Start Date] And <=[Forms]![103-Report Dates]![End Date]

I have a feeling that I somehow should be pointing my criteria first to '100-Select Form', and then to '103-Report Dates' within that form, but I'm just not sure how to write this and nothing I'm trying is working.

Thanks for any help!
- Ben

[June7]

I always give subform/subreport container control a name different from the object it holds, like: ctr103

Then:

BETWEEN [Forms]![100-Select Form]![ctr103]![Start Date] AND [Forms]![100-Select Form]![ctr103]![End Date]

[bdicarlo1]

That's getting me MUCH closer to what I'm trying to do....Thank you!!!