Date stamping

[loo]

I need to be able to date stamp fields based on when another field value changes. I only want the value to be entered once upon the change.
I have mutliple status that need to be tracked.
I need to know what date it became active
I need to know when that status field changes to approved
ect. there are 6 dates to be tracked for each record...so I have a date field for each one.

now I need to know how to fill those fields based on the value in the status field.

 

[GoDawgs]

If you make these changes on a form, just make text boxes that are linked to the necessary date fields...using the status field as an example, make a control for status and also one for status date, then when status is changed to anything run a test in the "on update" event for that text box, check if it is now "approved", then make the value of status date = today's date...something like this:

if [status]="approved" then
[status date].setfocus
[status date]=date()
end if

something like that should do the trick...hope that's what you're looking for.

Kevin