Which event to use to detect combo-box selection?

[Dorian]

Which is the best event to use to detect changes in a combo box selection?
I need to detect the date/time of every change to a combo box selection even
if it changes multiple times before the BeforeUpdate event.

-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Dirk Goldgar]

Which is the best event to use to detect changes in a combo box selection?
I need to detect the date/time of every change to a combo box selection
even
if it changes multiple times before the BeforeUpdate event.

I assume by "BeforeUpdate event", you mean the BeforeUpdate event of the
form, not the combo box. But you want to know every time the user changes
selections in the combo box, even if they do it multiple times before saving
the record.

I'd use the control's AfterUpdate event for this. You certainly *don't*
want to use the Change event, because if the user types into the control
instead of using the mouse, the Change event will fire with every keystroke.
I believe you *could* use the Click event, because that event has been
jiggered to behave similarly to the AfterUpdate event; however, it seems to
me "AfterUpdate" explains itself much better.

 

[John W. Vinson]

Which is the best event to use to detect changes in a combo box selection?

The combo box's BeforeUpdate event (if you want to be able to cancel that
change), or its AfterUpdate event (if you want to do something with the value
after it's been saved to the table).