Save value of combobox before it was updated

[greeknl via AccessMonster.com]

Is possible to save to a variable in VBA the value a combobox had before it
was updated in order to use it because the update value can be retrieved
easily

Thank you

--
Message posted via http://www.accessmonster.com

[greeknl via AccessMonster.com]

I forgot to mention that it is an unbound combobox.

Also is it possible with VBA to determine what control has changed. I have a
procedure which is triggered when a value from a combobox or txtbox changed.
I would like to be able to know in the procedure which control has been
altered

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200704/1

[fredg]

On Tue, 03 Apr 2007 20:49:39 GMT, greeknl via AccessMonster.com wrote:

Is possible to save to a variable in VBA the value a combobox had before it
was updated in order to use it because the update value can be retrieved
easily

Thank you

A control's previous value is the OldValue.
In the control's AfterUpdate event:

MsgBox Me![ComboName].OldValue

Remember, though, that a Combo's Value is the value of it's Bound
column, which is not necessarily what is displayed.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[greeknl via AccessMonster.com]

I have an unbound combobox.
Is there anyway to circumvent this problem

fredg wrote:

>Is possible to save to a variable in VBA the value a combobox had before it
was updated in order to use it because the update value can be retrieved
easily

Thank you

A control's previous value is the OldValue.
In the control's AfterUpdate event:

MsgBox Me![ComboName].OldValue

Remember, though, that a Combo's Value is the value of it's Bound
column, which is not necessarily what is displayed.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200704/1