help wih validate

[farizza]

someone can tell me what i can do for validate a textbox when you only let recorder in the databasee the number 1,2,3 and if you introduce another information,its send a error message
thanks for all
farizza reyes

[kovan]

farizza
salam.....
in the textbox keypress event
do it like this

'making sure only numbers are entered in this field
If Not IsNumeric(Chr(KeyAscii)) And KeyAscii <> _
vbKeyBack Then KeyAscii = 0


that will let you enter 0, 1-9,
and lets you use backspace as well