After the combobox is updated you can access the old value by If Me.Status.OldValue = "Broken" And Me.Status = "Working" Then ... HTH Liveson
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of tombrown1965 Sent: Tuesday, 22 August, 2006 12:50 PM To: [email protected] Subject: [ms_access] Comparing Combo Box before & after change 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 :) [Non-text portions of this message have been removed] 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/
