>>>to check for a duplicate code, i tried using this.setfocus in a valid method, but it doesn't seem to work.
>>>
>>>if !tableupdate()
>>> =messgebox('Duplicate code. Please reenter')
>>> this.setfocus()
>>>endif
>>>
>>>is there a better solution?
>>I don't believe setfocus works from inside valid events. I think you have to use the tab order and tab out of the control (or to your self) I had a form where if the zip was found we wanted to skip the city/state with setfocus and ended up using the taborder.
>>Gary
>
>You're right -- there is a KB bug doc on this. It basically says to use the lostfocus with nodefault instead to skip taborder...
I use return to move around from the valid method
return 0 (invalid, stay on field)
return (valid, stay on field)
return 1 (valid, move to next in tab order)
return -1 (valid, move to prev in tab order)
etc.