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.
---
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.