Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cascade prompts with static choices

Status
Not open for further replies.

handpass

Programmer
Oct 13, 2006
10
US
I have a finished report with one prompt page. This prompt page has two drop down list prompts.
In my first prompt I have 2 static choices. Depending on what is chosen in this first prompt I then want to display three more static choices in the second prompt, the values of which will depend on the first prompt selction. e.g.

IF Prompt1 = a
THEN
Prompt2 = a1, a2, a3
IF Prompt1 =b
THEN
Prompt2 = b1, b2, b3

I am hoping to have these two prompts on the one prompt page if that is possible. The values selected from the two prompts will be used as parameter filters in the report.

Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top