0

I have a report with 3 parameters (ReportType, DateRange, OrderNum) and I'd like to cascade them if possible. My record filter is working properly.

ReportType = 1 = All, 2 = By Date Range, 3 = By Order#

If Report Type = 1, then don't prompt for anything else
If Report Type = 2, Prompt for DateRange Parameter
If Report Type = 3, Prompt for OrderNum Parameter

DateRange ties directly to a field, but OrderNum does not because the DB field has leading 0's and I don't expect the user to enter the correct number of 0's

Bill
  • 1

0 Answers0