I am using Access 2007. I have a main table that has a field called "Date Returned". In the subtable, which is linked to the main table, I have a field "SSR Date" in which I want to calculate a date 7 days from the date of the "Date Returned" field.
I went into the property sheet for the "SSR DATE" field in the subtable and tried to put in the default value of =[MAINTABLENAME]![Date Received]+7.
It seems to be doing something but all I get in the field is "#NAME?"
Not sure what I am doing wrong....