Old and new values of combo box columns.

[Proko]

I use the before update event to find the old and new values of the bound
column of my combo box with:
cbo_mycombldValue and cbo_mycombo.Value

But, is it posible to find the old and new values of an unbound column in
the combo box with something like cbo_mycombo.Column(2).Value.

Any help would be greatly appreciated.

 

[Stuart McCall]

I use the before update event to find the old and new values of the bound
column of my combo box with:
cbo_mycombldValue and cbo_mycombo.Value

But, is it posible to find the old and new values of an unbound column in
the combo box with something like cbo_mycombo.Column(2).Value.

Any help would be greatly appreciated.

There's no built-in method, but you can easily roll your own. Create a
module-level variable to hold the old value. Call it (say) m_OldValue. Then
in your combo's GotFocus event, store the current value:

m_OldValue = Me.ComboName.Column(2).Value

Then, in the combo's BeforeUpdate event, use the variable to compare against
the current value:

If Me.ComboName.Column(2).Value <> mOldValue Then
MsgBox "They don't match!"
End If

Just curious: why do you want to do this?

 

[Proko]

Worked a treat! Thanks Stuart.
For the benefit of others, your line:
m_OldValue = Me.ComboName.Column(2).Value
should read
m_OldValue = Me.ComboName.Column(2)

The '.value' should be omitted.

 

[Stuart McCall]

Worked a treat! Thanks Stuart.
For the benefit of others, your line:
m_OldValue = Me.ComboName.Column(2).Value
should read
m_OldValue = Me.ComboName.Column(2)

The '.value' should be omitted.

<Homer's voice> Doh!