Blank graph still opens if no parameter values entered.

  • Thread starter Thread starter Ultraviolet47
  • Start date Start date
U

Ultraviolet47

Hi all

I have a graph based on a query:

SELECT Tbl_Sponsors.[Date Joined], Tbl_Sponsors.Adopt
FROM Tbl_Sponsors
WHERE (((Tbl_Sponsors.[Date Joined]) Between [Start Date (dd/mm/yyyy)]
And [End Date (dd/mm/yyyy)]));

so a user can see how many people joined withtin periods.

If the user cancels the request on Start or End date pop up boxes, it
still opens a graph, which is blank. Is there any way to stop it doing
this?

Also, I have tried an input mask for the query criteria (e.g 00/00/00)
but this doesn't seem to apply itself to the parameter pop up box?

Thanks,
 
I am assuming the graph is on a report. If so, create an [Event Procedure] on
the reports 'On No Data' property. In the procedure, put the code
Cancel = True
 
Back
Top