>Sorry for my poor english, "I" means user, who is doing data entry. I think the user will irritate if I generate this type of messages.
>
>Thanks - Saif
As I said in a previous message, you can go back to the previous field, based on some condition. You must decide what that condition is going to be.
if (some condition)
ThisForm.TxtDiscount.SetFocus()
endif
It is not clear to me what that condition is going to be. However, you can ask the user, with a MessageBox(), and check the return value; or you can go to the field if some other field is empty, etc.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)