>>>I have a combo box and its validate code attached to valid method. If a user wants to get out the form by clicking on the top of right hand corner X button. It always return a valid error message first before get out.
>>>
>>>I would like to avoid the valid code by checking what inkey code is for X close button (like escape key inkey code is 27). Any suggestions?
>>>
>>>Jim S
>>
>>That's a good example why it's not healthy practice to use Control.Valid events. IMHO, the right solution is to move all validations to cmdSave.Click event.
>
>Ed, this certainly solves the problem of avoiding the Valid clause for certain key-strokes. Unfortunately most of my clients want validation before they leave the field, not for all fields as they try to save the data. Does your scheme allow for this?
>
>Confused in California
>Barbara
Client is always right, so... BTW, it's better to use Interactive/ProgrammaticChange for validation purposes (see this thread case).
Edward Pikman
Independent Consultant