Open form based on subform criteria

[Guest]

I have a form "market" that includes 100 records of cities their details. I
have a subform on the page that lists television shows that correspond to
that market. I would like to open the form and have the subform display only
the tv shows in a specified date range. (Currently I have the subform
criteria set to open and prompt for a date range).

However, as i navigate from one record to the next on the main form, it
prompts me each time for the subform date range. Why does it do this and how
can i put the date range in just once?

 

[Guest]

If the subform is only used within this main form here's the approach I'd
probably take.

Prompt on opening the main form for the dates.
Place the 2 dates in hidden fields on the main form.
Instead of prompting from the subform, refer to the 2 hidden fields on the
main form.

hth,
James