It appears the OldValue method works only with a control which is bound to a field in the underlying record source. Here it works very well. If someone out there doesn't come up with a better solution I'd go for storing the value in a Static variable before the field is updated and compare it with the value after updating the field though it might sound a bit hectic. Good luck Liveson
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of tombrown1965 Sent: Wednesday, 23 August, 2006 12:03 PM To: [email protected] Subject: [ms_access] Re: Comparing Combo Box before & after change I have moved on, but have another problem: The combo box on the form has three values. When a user changes the box they are prompted with a message that tells them what actions will be taken based on the value they are changing from (Me!Status.OldValue) and the one they are changing to (Me!Status.Value) ... [thankyou ltumbulu]. They are prompted to proceed with or reject the change. If they reject then the code undoes the change (Me!Status.Undo), but the form still shows the value they changed to in the box - how do I get it to change back to the oldvalue? (I have tried Me.Repaint), but that doesn't seem to work. [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/
