hello i am having a problem with an IIF statement
=IIf([yesno].[Value]="yes",[date]=Date(),[date]="")
i have a form called form1 and two fields one is a yesno tick box and the other is a date field
i would like the date to = todays date if the yesno box is ticked! any ideas!?!?!
=IIf([yesno].[Value]="yes",[date]=Date(),[date]="")
i have a form called form1 and two fields one is a yesno tick box and the other is a date field
i would like the date to = todays date if the yesno box is ticked! any ideas!?!?!