louis
01-25-2002, 10:17 AM
I created a form to input the value of the criteria for a query. This works no problem.
The problem is that if user wishes to cancel they would click on the cancel button i created which is closing down the form but the report then throws up a "Grey Message Box saying Input parameter" How can i cancel the whole event. I tried using the cancelevent command on my macro which did nothing, i also tried adding another close command for the report but this gave an error. The quit command worked but this closes the whole database down, so thats no good.
I thought maybe there was something i could put in the query where if the value was blank the event would cancel. Either way I'm confused. Please Help.
Louis.
The problem is that if user wishes to cancel they would click on the cancel button i created which is closing down the form but the report then throws up a "Grey Message Box saying Input parameter" How can i cancel the whole event. I tried using the cancelevent command on my macro which did nothing, i also tried adding another close command for the report but this gave an error. The quit command worked but this closes the whole database down, so thats no good.
I thought maybe there was something i could put in the query where if the value was blank the event would cancel. Either way I'm confused. Please Help.
Louis.