Combo box event which only fires when value changes

[Jerry8989]

Hello,

I have a combo box that when changed I want to update a date column in one of my tables. The issue I'm running into is if a user selects the same value that was already selected the event fires and updates the date. I only want an update when the value completely changes.

I've tried on change and on dirty. What event would work best for this scenario?

Thank you

 

[MarkK]

What difference does it make? If the update works just fine, and the user updates the value to the same value, nothing is changed anyway, so why suppress the action? If it's not broken . . .

 

[pbaldy]

You can use the before update event and test the OldValue property against the Value property.

 

[Jerry8989]

Thank you pbaldy, That worked perfect

 

[pbaldy]

Happy to help!