In this post [post=”689866″]Post 689866[/post], you explained how I test for a range. This time I want to test for something that’s not in the range. Basically, I want to check if a tick box is not checked AND the part number is not in the range. So I have :-
If Me.Label_Checked = 0 And [Me.Stock_Code_No_1] Not In (“1Z51”, “1Z52″,”1Z53”) Then
This isn’t right I know, but I don’t know what should go after the last ].