Hello All,
I have a table box with an input field column that is inserted into a database via VB. When I refresh the file I run a ResetInputFieldValues macro as seen below to clear the values stored in the file and capture the data stored in the database.
sub resetinput
set fld = ActiveDocument.Fields("NoteA")
fld.ResetInputFieldValues 0' 0 = All values reset, 1 = Reset Possible value, 2 = Reset single value
end sub
I've set a button to execute the reload then the macro.
Problem is this will randomly cause an error reloading the script and exit out of the document forcing me to reload the file after a few reloads. Why would the macro above cause an error at times and not all the time?
Thanks for all your help!
