S
schmid
Basically I have a dynamic form with several date fields. One of which
is a "finish date". All of these fields have a control source of a
field from a table. When the value of the finish date is anything but
blank, meaning it has an actual finish date, I want to set the value of
another edit box to a value of "Closed". If there is no finish date I
want it to have a value of "Open".
I have tried several things here inluding expression builder and have
been unsuccessful. Does anyone have a quick and easy way to do this?
Thanks in advance!
Regards
schmid
is a "finish date". All of these fields have a control source of a
field from a table. When the value of the finish date is anything but
blank, meaning it has an actual finish date, I want to set the value of
another edit box to a value of "Closed". If there is no finish date I
want it to have a value of "Open".
I have tried several things here inluding expression builder and have
been unsuccessful. Does anyone have a quick and easy way to do this?
Thanks in advance!
Regards
schmid