Sorting in spreadsheet view on a form

[PMBott]

I have a database that I inherited, therefore I did not set it up. I have a form that has the record source as the tasks table. I know enough about access to get myself in "trouble" to make changes to the database. Although I do not know enough to change the record source to a query without breaking everything else, as I realize that a query is common setup protocol. Within the form I have a field called due date that I put in this formula =DateAdd('d',-[Days Out],[Start Date]). The form is in spreadsheet view. The formula is working just as I need it to, but when I view the form (in spreadsheet view) I need the due date field to be able to be sorted. I have altered the properities to order by tasks.due date and that does not work. Why am I unable to sort or do a orderby in this field. The other fields can be sorted but this one will not. Is it because there is a formula? Is there a work around?

Thanks
PMBott

[Robeen]

You could do your calculation in a Query by adding a 'Due_Date' field to the query:

Due_Date: DateAdd('d',-[Days_Out],[StartDate])

Sort the Due_Date field in the query.
Base your form on the query [Form - Property Sheet - Data - Record Source].

Hope this helps!