Validating a entry

[Nuno Gomes]

Hello,


I have a form liked to a table and my goal is not to enter the field NUM
null or repited.

I put some code (to check the repeated) in Private Sub NUM_Exit(Cancel As
Integer) event, but a have some problems...
What is the best way to do it?...




thanks,
Nuno Gomes

 

[John W. Vinson]

Hello,


I have a form liked to a table and my goal is not to enter the field NUM
null or repited.

I put some code (to check the repeated) in Private Sub NUM_Exit(Cancel As
Integer) event, but a have some problems...
What is the best way to do it?...

First off, make the field Required in your table (so it can't be null) and
also use the Index property of the field to create a unique Index.

For a friendlier error message, use the Form's BeforeUpdate event; this can
also be cancelled, and (unlike the exit event of the Control) it will always
fire if the record is being updated. The Exit event will never fire if the
user doesn't actually select the NUM textbox.