RETURN THE FOCUS TO THR FIRST FIELD

[LIORA]

THERE IS A FORM WITCH THE FIRST FIELD IS "HNUM"
I add a vbscript to afterupdate event of the field to
check if the val that entered is already exist in the
table - write a message if exist - and want to stay on the
same field after display the message .
I try to use the gotocontrol action with hnum control -
but after the message diplay the cursor move to the next
field.
How can I do it

Liora

 

[Wayne Morgan]

You may want to use the BeforeUpdate instead. After you display your message add a line
that says

Cancel=True

and you should stay at the control.

 

[liora]

Thanks is ok

liora

-----Original Message-----
You may want to use the BeforeUpdate instead. After you

display your message add a line