filtered subform problem

[bigmac]

hi , can you help please, I have a subform that has two fields one called 24 months(date field) and one called status(text field), what I am trying to do is after the suborm has been filtered if the date field and is <=date then it will place "expired" into the status text field . any ideas please

 

[bob fitz]

Perhaps something like:
= IIF([date field] <= Date(),"expired","")
as the Control Source property of text box called Status

 

[bigmac]

thanks , works great