I have a form which includes a combobox field (Status) with about 5
different options. I also have a number of timestamp fields that I
want to update based on when the field in the combo box changes.
This is easy if the update is just based on what i change the combo
field to, as I add this to the BeforeUpdate event
If Me!Status = "Working" Then
Me!Change1TimeStamp = Now
etc.
But I want the update to be based on what the field changes from &
to, so I want soemthing like
If Me!Status(original) = "Broken" AND Me!Status(newvalue) = "Working"
Then
Me!Change1TimeStamp = Now
etc.
But i cant see how I can access the pre-change value .. can anyone
help
PS - I would prefer not to have to use unbound fields as it means
more rework :)
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
