Thank you. It is for a law firm. The firm receives a set of documents from the client. I have a document checklist form which is used to check whether a specific document ( say, marriage certificate), is received or not. The checklist is for around 25 documents to be received from the client. An email is sent to the client for the missing documents and if all the documents are received a confirmation mail is sent to the client.
For the documents received, I have a combo box in the DocCheck form against each document where the user selects "received" or "not received" from the drop down, once done, the user click the command button to send email for the missing document(s) or confirming all the documents are received.
Please let me know if I am not making it clear. Thanks.