Checkbox set in vba not set on reopen of form

Question

Hello I am setting these checkboxes programmatically in Excel and on first pass they are set. However when I reopen the document after saving they are not set. I was wondering is there a way to set them and keep them set the way I programmed them to be.

Code adapted from:

https://myengineeringworld.net/2013/10/read-and-write-pdf-forms-from-excel-vba.html

'All checkboxes to checked
objJSO.GetField(strFieldNames(22)).Value = 1
objJSO.GetField(strFieldNames(23)).Value = 1
objJSO.GetField(strFieldNames(24)).Value = 1
objJSO.GetField(strFieldNames(25)).Value = 1
objJSO.GetField(strFieldNames(26)).Value = 1
objJSO.GetField(strFieldNames(27)).Value = 1
objJSO.GetField(strFieldNames(28)).Value = 1
objJSO.GetField(strFieldNames(52)).Value = 1

Milestonesfoto · Answer

It was the write section. To resolve the problem I recreated the form and that eliminated the issue. I was using the form straight from the VA.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.