I am using Access 2007 on Windows XP Professional.
That out of the way, here is my issue. It involves forms and reports and tables so the General forum seemed as good as any!
I have a form that people use to enter data to a "Project Entry" table. All of my forms, reports, etc, feed from this table.
On my Project Entry form, I have the following code that executes when someone types in the due date:
=IIf(DateDiff("d",Date(),[Date Due])<14,"A",IIf(DateDiff("d",Date(),[Date Due])<30,"B",IIf(DateDiff("d",Date(),[Date Due])<60,"C","D")))
It works perfectly - or so I thought.
Let's say when the project is entered, it's a D priority. When it becomes a C, my reports (which also use that code for the text box of priority), will update, but the actual "Project Entry" table does not.
This is now a problem, because I want people to be able to sort/search by priority code. Is there a way to fix this short of going in every morning and manually pushing the Project Entry form to update that field?
Thank you!
Teresa