https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/100444.aspxSun, 07 Dec 2014 08:50:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:100444donstephen0https://www.infopathdev.com:443/forums/thread/100444.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=100444<p>Hi Sephaerius,<br /><br /></p><p>I haven&#39;t&nbsp;done any InfoPath-Access work yet but&nbsp;I would suggest querying&nbsp;Access with the Account Number first. If the data connection returns data (number of rows &gt; 0), then you could halt the submit process and display an error message like&nbsp;&quot;The Account Number already exists. Please enter a different Account Number&quot;.&nbsp;Otherwise (if number of rows = 0), continue with the&nbsp;submit logic. I hope this makes sense.<br /><br />Regards,</p>https://www.infopathdev.com:443/forums/thread/100430.aspxFri, 05 Dec 2014 13:21:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:100430Sephaerius0https://www.infopathdev.com:443/forums/thread/100430.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=100430<p>Hi,</p><p>I&#39;m brand new to InfoPath so bear with me. I&#39;ve setup a form linked to an Access database - seems to work fine so far. My endgame is to have about 100 users or so submit requests into this database via the infopath form, however duplicate submission could be a problem. Is there a way I can throw a validation error (or the like) when the Submit button is clicked if the form detects that the text in the Account Number field already exists in the database?<br /></p>