It's just an 'if' statement

Incisor

Registered User.
Local time
Yesterday, 17:46
Joined
May 15, 2003
Messages
16
I am missing something obvious here. Why does this if statement fail.


---

ElseIf [cmbSEQ] = Null And [cmbSPC] = Null And [cmbXnum] Is Not Null Then

---

these mods fail as well
--
[cmbXnum] <> Null
[cmbXnum] <> ""
---

All combos are defaulted to Null..I have tried defaulting to "" as well.

When I select a value for cmbXnum and click the button holding the 'if' structure snippet above it just sails on by.
 
I think that it is this instead:
ElseIf isnull([cmbSEQ]) And isnull([cmbSPC]) And not isnull([cmbXnum]) Then
 
Presto...Thanks a bunch.
 

Users who are viewing this thread

Back
Top Bottom