Calculation on Date shows #Name?

[Trevor G]

I have a form where I have a real simple calculation which is looking at the date and subtracting a date recorded in each record, every record has a date and the field is called [SelectedDate] this is date/time field and format is set to short date, but occasionaly the date calculations shows

#Name? which then prevents me using another command button to select the next form based on the selected record. The calculation is:

=Date()-[SelectedDate]

I really don't see why the calcuation causes a period issue.

 

[healey21]

Trevor place the calculation in the query that drives your form, you can rename the expression, that should then resolve the calculation not displaying properly from time to time on the form.

 

[Trevor G]

Thanks Healey21 I have done this and it has resolved the issue. So happy enough its done that.