I have an MS Access Form with one bound field, ExpirationDate and one unbound field ExpirationBlendDate.
The ExpirationDate default value is calculated (=DateAdd("yyyy",5,[CreationDate])
The ExpirationBlendDate is populated from a combo box using an After Update event (ExpirationBlendDate = Combo20.Column(3))
I'd like to compare the ExpirationDate to ExpirationBlendDate, and write the older date to the ExpirationDate field. I tried adding the following line into the same After Update event, but it's not working...
ExpirationDate = IIf([ExpirationBlendDate] < [ExpirationDate], [ExpirationBlendDate], [ExpirationDate])
Can you let me know how I might fix?
Thanks in advance for the assist.