Values unbound textbox based on calculation of 3 other fields

[Pluggie]

Five fields on my continuous form:
-ID
-Date_Today (date)
-End_Date_Contract (date)
-Duration_Update_Process (numeric)
-Warning (text)

Calculation that determines value of [Warning]:

-If number of days between [End_Date_Contract] and [Date_Today] is equal to
or smaller than [Duration_Update_Proces], display textvalue: "Almost too
late";
-If number of days between the above fields is bigger, display textvalue: ""
-If number of days between the above fields is negative, display textvalue:
"Oh no! Too late!!!"

How do I get this to work in [Warning]?

 

[Klatuu]

I would suggest you use the form Before Update event to test the values and a
message box to display the messages.

 

[Pluggie]

Thanks for the intent, but I need the messages to appear as part of the
continuous form, so in an unbound textbox. The application will be webbased
and later on, I want certain messages that are displayed to trigger
auto-emails.
So, any other suggestions?

I would suggest you use the form Before Update event to test the values and a
message box to display the messages.
--
Dave Hargis, Microsoft Access MVP

Five fields on my continuous form:
-ID
-Date_Today (date)
-End_Date_Contract (date)
-Duration_Update_Process (numeric)
-Warning (text)

Calculation that determines value of [Warning]:

-If number of days between [End_Date_Contract] and [Date_Today] is equal to
or smaller than [Duration_Update_Proces], display textvalue: "Almost too
late";
-If number of days between the above fields is bigger, display textvalue: ""
-If number of days between the above fields is negative, display textvalue:
"Oh no! Too late!!!"

How do I get this to work in [Warning]?

 

[Pluggie]

Thanks for the intent, but I need the messages to appear as part of the
continuous form, so in an unbound textbox. The application will be webbased
and later on, I want certain messages that are displayed to trigger
auto-emails.
So, any other suggestions?

I would suggest you use the form Before Update event to test the values and a
message box to display the messages.
--
Dave Hargis, Microsoft Access MVP

Five fields on my continuous form:
-ID
-Date_Today (date)
-End_Date_Contract (date)
-Duration_Update_Process (numeric)
-Warning (text)

Calculation that determines value of [Warning]:

-If number of days between [End_Date_Contract] and [Date_Today] is equal to
or smaller than [Duration_Update_Proces], display textvalue: "Almost too
late";
-If number of days between the above fields is bigger, display textvalue: ""
-If number of days between the above fields is negative, display textvalue:
"Oh no! Too late!!!"

How do I get this to work in [Warning]?