>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
Gary
Helping Make Ideas Reality