Open form based on subform criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tarheelkate - 02 Mar 2007 14:41 GMT

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?

Reply to this Message

JamesDeckert - 03 Mar 2007 17:59 GMT

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

> 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
[quoted text clipped - 5 lines]
> 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?

Reply to this Message