>sorry Nadya, Stale cache I didn't see your response.
Sorry Glen,
I was telling Peter, that I gave him the same response as Sergey but few seconds (or minutes) earlier... Your response was just fine and the more complete.
>
>Glenn
>>Didn't I tell the same?
>>
>>>Works great now, thanks!!
>>>
>>>>>Normally I have a CLOSE button and put my error checking in there... but I am concerned with the CLOSE (X) being used in this case and don't know where to put it.
>>>>The ryUnload Event will fire in this case. Put NODEFAULT to prefent a form from closing.
>>>>
>>>>>
>>>>>>>When a user closes a form, DESTROY appears to be the first method fired that I can tell. If I put error checking in there, how can I, with a messagebox, send the user back to the form if they want to fix an error and NOT finish releasing the form? I have been guessing at some possibilities but they all seem to continue on and close the form.
>>>>>>
>>>>>>It depends how a form is closed. Take a look at QueryUnload Event in the help.
If it's not broken, fix it until it is.
My Blog