I am attempting to read field values from a PDF form created with Adobe LiveCycle using VBA (Microsft Access 2010).
I believe Acrobat Pro must be installed on the system, Reader will not suffice.

I found an article with the following example:

    Dim AcroApp As Acrobat.CAcroApp
    Dim theForm As Acrobat.CAcroPDDoc
    Dim jso As Object
    Dim text1, text2 As String

    Set AcroApp = CreateObject("AcroExch.App")
    Set theForm = CreateObject("AcroExch.PDDoc")
    theForm.Open ("C:\temp\sampleForm.pdf")
    Set jso = theForm.GetJSObject

    ' get the information from the form fields Text1 and Text2
    text1 = jso.getField("Text1").Value
    text2 = jso.getField("Text2").Value

    MsgBox "Values read from PDF: " & text1 & " " & text2

    ' set a text field
    Dim field2 As Object
    Set field2 = jso.getField("Text2")

    field2.Value = 13   ' assign the number 13 to the fields value

    ' get the information from the form fields Text1 and Text2
    text1 = jso.getField("Text1").Value
    text2 = jso.getField("Text2").Value

    MsgBox "Values read from PDF: " & text1 & " " & text2

    theForm.Close

    AcroApp.Exit
    Set AcroApp = Nothing
    Set theForm = Nothing

    MsgBox "Done"

Select allOpen in new window

However, providing a field name from my PDF to getField() did not yield an object.

I found another article that indicated that forms created with LiveCycle had to be accessed via the XFA object.

jso.xfa.Form.form1.RMPCR.txtMerchant.rawValue

Select allOpen in new window

The above code block is for my PDF, it resulted in a runtime error.
I am not sure if this approach is totally incorrect or if my property chain is just wrong.