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

"Ultraviolet47" wrote:

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