CancelEv ent Problem

[heidihutton]

I have a form that pops up to collect query parameters for a report. If you click on the cancel button on that form, a pop up box comes up requesting the parameter value. How do I stop that from happening? I have put a CancelEvent in a module but it doesn't seem to work properly.

All help is appreciated.
Heidi

 

[cghoga]

Hello Heidi.

try inserting
Cancel = True
or
Exit Sub

if an error message then comes up set up an error handler


On Error GoTo Errorhandler

'at the bottom of your proc
Errorhandler:
if err.number = YourErrorNumberGoesHear then
err.clear
End If

 

[valkyry]

Fill rate?

Need to somehow figure out how to determine what % of orders can be filled from what's in inventory?