Open form based on subform criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Main Form and two Subforms 2
Unremovable horizontal scroll bar on subform 1
Subform 7
First Subform record gets modified when closing form 3
Search criteria not passing to subforms 2
Access Main form/Subform Navigation 0
Go to a Specific Record on a Subform 3
Multiple date parameters 5

Back
Top