Update field

[thesuggs76]

Hi All
I want a field in a form to update to yes when a date is entered in a date field.
So until a date is entered the default value is no, when the date is entered i want it to change to yes.
Thanks

 

[boblarson]

Well, I hope you aren't storing that information, because that is storing redundant information (a no no if properly normalized). You should be either storing the yes or the date, and I'm assuming that the date is important so you shouldn't be storing the yes because you can easily tell from the value of the date field if it is yes or no. So, to DISPLAY it on the form you can use this in the text box's control source:

=IIf(Len([DateFieldHere] & "") > 0, "Yes", "No")