I am trying to develop and DB specifically for the web. I have created a form with calculated fields on it, when a new record is created via IWP the default result is placed into the field - That parts OK. Once information is entered into the field the calculated field does not change. Any suggestions would be great.

*** This is the calc ***

Case(Exact( DayName ( ServiceDate1 &"/"&"01"&"/"&$$CurrentYear ); "Monday") and Exact(ServiceMonday;"Yes");TextColor("Access OK";RGB(0;0;255));

Exact( DayName ( ServiceDate1 &"/"&"01"&"/"&$$CurrentYear ); "Tuesday") and Exact(ServiceTuesday;"Yes");TextColor("Access OK";RGB(0;0;255));

Exact( DayName ( ServiceDate1 &"/"&"01"&"/"&$$CurrentYear ); "Wednesday") and Exact(ServiceWednesday ; "Yes");TextColor("Access OK";RGB(0;0;255));

Exact( DayName ( ServiceDate1 &"/"&"01"&"/"&$$CurrentYear ); "Thursday") and Exact(ServiceThursday ; "Yes");TextColor("Access OK";RGB(0;0;255));

Exact( DayName ( ServiceDate1 &"/"&"01"&"/"&$$CurrentYear ); "Friday") and Exact(ServiceFriday ; "Yes");TextColor("Access OK";RGB(0;0;255));

Exact( DayName ( ServiceDate1 &"/"&"01"&"/"&$$CurrentYear ); "Saturday") and Exact(ServiceSaturday ; "Yes");TextColor("Access OK";RGB(0;0;255));

Exact( DayName ( ServiceDate1 &"/"&"01"&"/"&$$CurrentYear ); "Sunday") and Exact(ServiceSunday ; "Yes");TextColor("Access OK";RGB(0;0;255));TextColor("No Access";RGB(255;0;0)))

Refresh the window?

Is this the complete calculation? Where is the variable $$CurrentYear defined?

Do variables work through IWP?

Is the calculation unstored?

Thanks for the replies. As far as I can tell $$CurrentYear is being picked up correctly from the web interface. All calcs are non-stored "Text" results. I am a little crapped that such simple things don't work on both sides (Native and Web)

I will seek help from FM.com.au directly.

Thanks for the input. Refreshing the window does not fix the issue. It would be great if it did!!