I didn't change the name of the table. i changed the name of the text box within the table. I then went back into my form, deleted the code and text box associated with the datediff name and added the text box DD. I then recoded my button to look like this.
Dim d1, d2, d3 As Variant
d1 = Date...