Access 2002 Validation Rule Question

[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

 

[CSmith]

Hi,

Perhaps you should try ">= 0" since 0 is not > 0.

 

[CSmith]

Sorry, I meant <> 0. Hope that helps.

 

[Carl]

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