https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/63563.aspxWed, 26 Jan 2011 11:30:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:63563duffer730https://www.infopathdev.com:443/forums/thread/63563.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=63563<p>I have two controls.&nbsp; The first is a drop down selector with options of 1-5.&nbsp; The second is a text box.&nbsp; Both are set to use Data Type: Whole Number.</p> <p>I then want to use Data Valaidation to ensure the following;</p> <ul> <li> <div>If field 1 is set to 1 then field 2 must be between 0 and 49,</div></li> <li> <div>If field 1 is set to&nbsp;2 then field 2 must be between&nbsp;50 and 89, </div></li> <li> <div>If field 1 is set to&nbsp;3 then field 2 must be between 90 and 110, </div></li> <li> <div>If field 1 is set to&nbsp;4 then field 2 must be between&nbsp;111 and 150, </div></li> <li> <div>If field 1 is set to&nbsp;5 then field 2 must be between 151 and 200</div></li></ul> <p>My conditions&nbsp;are;</p> <ul> <li> <div>If field 1 = 1 AND field 2 is greater&nbsp;49 display error 1</div></li> <li> <div>If field 1 =&nbsp;2 AND field 2 is less than 50 OR greater than&nbsp;89 display error 2</div></li> <li> <div> <div>If field 1 =&nbsp;3 AND field 2 is less than 90 OR greater than&nbsp;110 display error 3</div></div></li> <li> <div> <div> <div>If field 1 =&nbsp;4 AND field 2 is less than 111 OR greater than&nbsp;150 display error 4</div></div></div></li> <li> <div> <div> <div> <div>If field 1 =&nbsp;5 AND field 2 is less than 151 OR greater than&nbsp;200 display error 5</div></div></div></div></li></ul> <p> <div> <div> <div>When testing it works fine for condition 1 and also for condition 2, but if for example&nbsp;field 1 is set to 3 AND field 2 is set to 100 (which should be a valid condition) it throws error 2 at me.&nbsp; In fact it throws error 2 at me if field 1 is set to 3,4, or 5.</div> <div>&nbsp;</div> <div>It only seems to work fine for the first two conditions, if i try and test it for condition 3,4 or 5 then regardless of the value in field 2 it throws error 2 at me.</div> <div>&nbsp;</div> <div>Any advice or help appreciated!</div> <div>&nbsp;</div> <div>Regs,</div> <div>Richard</div></div></div>