To preface, I cannot use the Primary Key to prevent duplicates. There are already 4 Primary Key fields in the table I am writing to, and 3 of those are transaction information that change with each transaction.
That said, I have a base form linked to a table ("Docs") where my users select a document and transmit it. After they select all of the documents, they move to the transmit screen for a cleaner view, also linked to "Docs". They transmit the document(s) and the information is saved in a table for reporting, troubleshooting, etc. ("Hist").
In the transmit screen, the users set the revision of the document, as well as it's status and the transmittal information (Sender, Recipient, Sequence Number). What I am trying to do is check in "Hist" if the revision has been issued before. The revision was linked to "Docs", but I have made it unbound in a new attempt to check, but it is still failing to work properly. It can be easily linked again if a possible solution requires this. I was using some "If Not IsNull(DLookup())" series I found on the web, but it seems to only want to check the table that is linked to the form, not another table in the database. Unfortunately, I have destroyed the code I found, so I cannot post to see if that would work. I'm really stuck, so any help is greatly appreciated.