Setting a Date based on another Date in a subtable

[jessicamosby]

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....

[ItsMe]

Perhaps you can format the control SSR DATE as Short Date or something that relates to the data type of "Date Received"

[June7]

Try:

=[Forms]![MAINTABLENAME]![Date Received] + 7

[ItsMe]

Blimy! I missed that.

[jessicamosby]

Thank you so very much!!!