Actually, this was a hint.
Anyway, forget it :)
>Sure did, almost within minutes of one another, that's why I replied to both of you... was easier then sending two seperate messages
>>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