Search results

I did not - only AfterUpdate.

Ahh this is working! Had to add an additional "[" after Me! and remove a ")" from "HR]))" but it looks good for that record. One thing I noticed though is when I open a new record it carries the info in Text166 onto that record. It disappears after I enter the 2 dates with the correct info. Any...

Thanks for the quick response. So you are saying to not use the AfterUpdate on Date Projection sent to HR but use the Form's AfterUpdate? (also I am unfamiliar with Current!) How does access know what update I am referring to? When I go into the Form's properties: On Current....... Before...

I hate to ask again since I have never been a fan of "bumping" but I am still hoping for an answer. This is the last problem I have to figure out on this project. Thanks in advance

I think I spoke too soon because I misread your email thinking you said to use AfterUpdate events for Total Business Days and SLA met? How would I instruct the AfterUpdate to link with Total Business Days? Seeing as Date Projection sent to HR is the second date needed to fill in to make...

I am not at work until Monday but that sounds exactly what I need. PLEASE SEE BELOW I really appreciate you help! :D

Hello everyone - I have created a form on Access 2003 that has 4 fields: Date Completed Info Received Date Projection sent to HR Total Business Days (which is a calculation of the difference between the last 2 fields using "=calcWorkDays([Date Completed Info Received],[Date Projection sent to...