topic Inputfield not resetting on reload. in QlikView

Inputfield not resetting on reload.

Mon, 01 Mar 2010 16:32:08 GMT

I am using the following code:-

Inputfield Fcst_StartDate;

Load

Monthstart(now()) as Fcst_StartDate

Autogenerate(1);

First time I Load the application, the date in the field Fcst_StartDate is 01/03/2010 as I would expect. I then manually enter a date in the field say 27/02/2009.

When the app reloads 27/02/2009 is retained in the Fcst_StartDate.

How do I reset the field to the Monthstart formula when the app reloads?

Inputfield not resetting on reload.

Mon, 01 Mar 2010 16:56:51 GMT

Paste using an idea I found on the previous post on this subject I set the following macro to reset the input field using the onopen action in the doc settings.

Sub Reset_Inputfield

"Fcst_StartDate").ResetInputFieldValues 0

end sub

This works when I reopen the document.

Inputfield not resetting on reload.

Mon, 01 Mar 2010 17:24:47 GMT

Sorry the correct code is

Sub reset

activedocument.fields("Fcst_StartDate").ResetInputFieldValues 0

End sub