Hi,

how can restrict to user that without enter record not move to
next field ?
what changing in properties?

user should enter zone value i.e. 1 or 2 or 3 if user move without insert records it give message that enter record and stop in
this field ?


Private Sub ZONE_LostFocus()
....

End Sub


regards

Mateen

At the table level, for the field you want to add data validation to:

Validation Rule: = 1 Or 2 Or 3
Validation Text: Please enter a valid zone number
Required: Yes or No

If you enter 4 in this field, you get the message "Please enter a valid zone number"

If you enter 1, for example, you get no error message and move on.

If you want them to have to enter a zone number, make the field required.

Does this help?

mmcdonal

Thanks.