RETURN THE FOCUS TO THR FIRST FIELD

  • Thread starter Thread starter LIORA
  • Start date Start date
L

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
 
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.
 
Back
Top