Input Field Reset Macro Question

Mon, 09 Jan 2017 16:38:44 GMT

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!

topic Input Field Reset Macro Question in QlikView

Input Field Reset Macro Question