We have a machine where is is now routine maintenance to change the "suckers" on it every 8 days. I use a query to give me the amount of days since last sucker change. On a form I use the source below to show the result.
=DLookUp("downtime","suckers")
I use conditional formatting to display this value in red when 8 days have passed. But what I really want is if the figure is 8 to pop-up a message box saying "Routine Maint required." I have used on current etc of the main form which the value is displayed on but can't trigger the macro for the message box. Is it possible?
=DLookUp("downtime","suckers")
I use conditional formatting to display this value in red when 8 days have passed. But what I really want is if the figure is 8 to pop-up a message box saying "Routine Maint required." I have used on current etc of the main form which the value is displayed on but can't trigger the macro for the message box. Is it possible?
