report error msgs

[ai_enjoi via AccessMonster.com]

hello..
i have a report that would require the user to select a date range... if the
date range is invalid, some fields would show Error# ...and i don't want this.
how can show an error msg evrytime the date range is invalid... ??? thank
you..

 

[adamlow71]

hello..
i have a report that would require the user to select a date range... if the
date range is invalid, some fields would show Error# ...and i don't want this.
how can show an error msg evrytime the date range is invalid... ??? thank
you..

You might want to redirect the input to another form that ask for the
start date and then the end date, and a button that will click to go
to the report itself, taking the date from this page.

In that way, you can use the form itself to control the information
that will go to the report, and do your own custom error message such
as the valid date to use and so on, as a prompt to get the report.

Hope that helps.