Search results

Hi How I do this is to set up the mail merge documents with the merge fields pre-inserted, then in your access DB make a query which pulls the ONE record you want to use for that contract. How I would suggest for you to do would be your button to 'generate contract' which opens your word doc...

Would you be able to strip any confidential data and upload a copy of the db? I can certainly take a look if still required.

Wow that was a fast response, not to worry as I appeared to have found the solution to my own problem a minute or two after posting! For anyone else who may be in the same situation - here's the code I am using now Option Compare Database Sub AuditChanges(IDField As String, UserAction As...

Hi Gina I am in the same situation as you with the same code - have you had any progress on making the code work for the subforms? Any comments or suggestions would be appreciated! Thanks,