I'm trying to calculate a date field on a subform based on a date field on the parent form using the following expression in the control source of the subform's date field i'm trying to calculate:
( I want the field to be 10 days from the Admission Date)
=DateAdd("d",10,[Forms]![frmAdmissions]![AdmissionDate])
I keep getting this error #Name?. Any ideas?
( I want the field to be 10 days from the Admission Date)
=DateAdd("d",10,[Forms]![frmAdmissions]![AdmissionDate])
I keep getting this error #Name?. Any ideas?