>>I have several textboxes that I am using within a form that is being used for data entry.
>>
>>I am using the the textboxt Valid Event to run a query (if the textbox is not empty) based on the value entered in that textbox. The code is basically as follows:
>>
>> IF NOT EMPTY( This.value)
>> rc_custno = ALLTRIM( This.Value)
>> ThisForm.m_query()
>> ELSE
>> WAIT WINDOW "Customer # must be entered"
>> ENDIF
>>
>>However, if I don't enter a value and decide to exit the form by using a command button set up for thisform.release(), it still runs teh valid event (ofcourse) and gives me the WAIT WINDOW message.
>>
>>Ideally I would want this code to fire only when I press TAB or ENTER, and I know that I should be using the KEYPRESS event or sort of it, but I can't get the syntax correct. help.
>>
>>Thanks,
>>
>>Alex
>
>Here is another method you could try that I have found successful. Rather than putting your query code in the valid event, add a custom method to your form -- you could call it myquery. Put the code that you posted above in this method. Then, in the interactive change event for your textbox, you can put this code --
>
>This.tag = 'a' && or anything else
>
>Finally, in the valid event for your textbox, put something like this --
>
>IF !EMPTY(This.tag)
> ThisForm.myquery()
>ENDIF
>
>I have found this method to be successful for me. Good luck!
Iteresting idea. I will remember this one. Though KeyPress should do the work too...
If it's not broken, fix it until it is.
My Blog