Combo box event which only fires when value changes (1 Viewer)

J

Jerry8989

Registered User.

Local time

Today, 18:15

Joined

Mar 16, 2006

Messages

64

• Sep 29, 2015

• #1

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

bit cruncher

Local time

Today, 15:15

Joined

Mar 17, 2004

Messages

8,181

• Sep 29, 2015

• #2

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

Wino Moderator

Staff member

Local time

Today, 15:15

Joined

Aug 30, 2003

Messages

36,125

• Sep 29, 2015

• #3

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

 

J

Jerry8989

Registered User.

Local time

Today, 18:15

Joined

Mar 16, 2006

Messages

64

• Oct 1, 2015

• #4

Thank you pbaldy, That worked perfect

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 15:15

Joined

Aug 30, 2003

Messages

36,125

• Oct 1, 2015

• #5

Happy to help!