Access 2002 Validation Rule Question

  • Thread starter Thread starter Carl
  • Start date Start date
C

Carl

I am using a combo box with a query behind it to select
from a valid name from a list. From this list I get an
account number (the source is a primary key - acctno). I
set a validation rule: > 0 (I also tried AcctNo > 0).
However, when I add a new record and do not select a name
from the list the Validation rule does not kick in.

I used the Watch window in VBA to see what the results of
the field were when I exited and the results show as 0.

Why isn't the validation error warning me about this
blank field?

Thanks
 
Thank you for the suggestion. Unfortunately, even when
entering <> 0 as the validation rule I am able to exit
the combo box without anything selected and with no error
appearing.

Carl
 
Back
Top