InfoPath Dev

 So just to verify, you are suggesting to create a new table containing an ID and Status for each submitted form.  Each time the form is opened (or re-opened) I need to query the status to detect whether or not that user has submit the form previously.  That sounds like it could work.  Is there a way to assign that status ...

I currently have an InfoPath Form that sends the data through a three-tier approval process before being sent to an Access database.  The general process is as follows: If all Users approve the data in the form: Submitter -[email]> Tier 1 User -[email]> Tier 2 User -[email]> Tier 3 User -[main submit]> Database However, if at ...