Old and new values of combo box columns.

  • Thread starter Thread starter Proko
  • Start date Start date
P

Proko

I use the before update event to find the old and new values of the bound
column of my combo box with:
cbo_mycombo.OldValue 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.
 
Proko said:
I use the before update event to find the old and new values of the bound
column of my combo box with:
cbo_mycombo.OldValue 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.
Click to expand...

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?
 
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.
 
Proko said:
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.
Click to expand...

<Homer's voice> Doh!
 
Back
Top