>>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...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.