Hi All
Not got a huge amount of experience with VBA. But here is what I am trying to do. I have a database to track warranty claims returned to our suppliers. Each claim has a sequential number. I have already inserted code so that when a claim is entered it sends a task to outlook with the suppliers name and claim reference in the Subject along with some standard text.
Now what I want to do is to be able to update the task from access. I have a field that has the warranty status with a default value of "Pending". What I would like is if I update this field with directly in the table or through a form then I want the task status to change so that I dont get my automatic task pop up after the set period of time.