That's fine Good luck Liveson _____
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Brown, Tom Sent: Wednesday, 23 August, 2006 7:45 PM To: [email protected] Subject: RE: [ms_access] Re: Comparing Combo Box before & after change Thanks Actually I read on another thread that you need to set Cancel to True before you do the undo, so I added the line Cancel = True & then Me!Statsu.Undo And it worked! Not at all sure why or how .. but it works! ________________________________ From: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com [mailto:[EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com] On Behalf Of L Tumbulu Sent: 23 August 2006 15:29 To: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com Subject: RE: [ms_access] Re: Comparing Combo Box before & after change 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:ms_access%40yahoogroups.com> ps.com <mailto:ms_access%40yahoogroups.com> [mailto:[EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com <mailto:ms_access%40yahoogroups.com> ] On Behalf Of tombrown1965 Sent: Wednesday, 23 August, 2006 12:03 PM To: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com <mailto:ms_access%40yahoogroups.com> 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] [Non-text portions of this message have been removed] [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/
