Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Input Field Reset Macro Question

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!