I would like to use Access VBA to auto populate a pdf form that has been created using Adobe Experience Manager (AEM) Designer. Is this possible? Or, can this only be achieved with a flatten pdf file? I can easily populate a flattened pdf form, but, because I'm not the owner of most of the pdf forms that need to be populated, I was wondering if it's possible to achieve this with AEM forms? and if so, how?

I know that AEM form auto-population can be achieved by connecting a data source directly to the form through AEM, but, I would like to be able to use VBA code from within Access to allow users to select a record and then click a button to populate the form automatically.

Any help, suggestions or recommendations would be greatly appreciated !