Re: Validation

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

hi,

Newbie wrote:
The problem I'm facing is when the user wanting to quit and close the form, they will have to enter/select a value into a CboCommCode in order to click the Close button to exit out of the form.
Don't use the On Exit event of the combo box. Use the Before Update event of your form to validate _all_ your values. If the validation fails, set Cancel = 1.

mfG
--> stefan <--
.

Relevant Pages

  • Re: Help! GO TO and PERFORM THRU!
    ... the validation fails ... I have personally heard many criticisms of the COBOL GO TO statement ... MOVE 1 TO WS-SUB. ... want to exit a section I do just that with the EXIT SECTION statement. ...
    (comp.lang.cobol)
  • Re: Cancel buttons ActiveControl reflects as value of text box
    ... cannot use a Cancel button on your form to achieve what you want to. ... Remove the code from the text box's Exit event. ... is empty. ...
    (microsoft.public.access.formscoding)
  • Re: Cancel buttons ActiveControl reflects as value of text box
    ... cannot use a Cancel button on your form to achieve what you want to. ... Remove the code from the text box's Exit event. ... BeforeUpdate event of the *form* (not control.) That's actually the only way ...
    (microsoft.public.access.formscoding)
  • Re: Tab Action
    ... You can use the EXIT event for the textbox. ... of the code window and you'll see the available events. ...
    (microsoft.public.word.vba.general)
  • RE: on exit field
    ... I don't think you are going to prevent the On Exit event firing. ... only include code within the On Exit event sub to exit the sub under ...
    (microsoft.public.excel.programming)