J
Jeanke
Hello
I have a table in which I have a field PO number.
Before going to a form to change a PO, I have a pop up with an unbound text
box on it and would like it to do following :
1) Check whether you filled something in the text box before you press a
button change
--> already have this working via the isnull function
2) Check whether the number entered is 10 digits
--> no idea how to do this
3) Check whether this number exists in the table above
--> also no ide
any help would be highly appreciated
I have a table in which I have a field PO number.
Before going to a form to change a PO, I have a pop up with an unbound text
box on it and would like it to do following :
1) Check whether you filled something in the text box before you press a
button change
--> already have this working via the isnull function
2) Check whether the number entered is 10 digits
--> no idea how to do this
3) Check whether this number exists in the table above
--> also no ide
any help would be highly appreciated