Honestly, I've never done anything with digital signing of PDFs aside from using online tools like Docusign, and that's only when my lawyer or realtor sends me something to sign digitally. Does anyone else have any experience with this?

One way I would suggest is using a template fillable PDF with the digital signature blocks where you need them.  If the form doesn't exist, then you could make one with various PDF design tools.  Each fillable field in the PDF will have its own unique name, either "Field1, Field2,..." or customize names assigned by the PDF author. These can be filled or read using the Adobe SDK.

Then use VBA and the Adobe SDK to create a new output copy PDF populated from your database.  Pass the populated form to the end user have them sign the PDF and pass it on to where it needs to go.  You could also use the SDK to read from the signed PDF to capture signature meta data.

I ran it by ChatGPT for sample code and followed up with how to sign individual records in the database.  You basically use a PKI tool kit like OpenSSL.  You create a "document" that is text of the values that you want to lock into the signature process the sign that "document".  That way you know the field values when it was signed.  You will also want to have some minimal way of validating signatures too.

https://chat.openai.com/share/2f17bfa6-7849-42e0-b3e0-cc38839292fd

That's a very handy resource. Thank you for sharing, Brian.

Let me see if I can find the database I made it prints to PDF but the signature block has to have the words signature under a line.  when it print from access it places the digital signature block on the form.   no need to prep the form after that.  I have it at work so If you dont see it from me son hit up again chances are I will have a senior moment and forget.

V/r
Juan

Thanks for all the help guys.  As always y'all are an amazing team!  :-D