Pl Help...checkbox value when checkbox is cleared (1 Viewer)

[gdanalakshmi]

I have a combobox in a form. If I select a value from the list, I check a checkbox. But when I delete the word that appears in the combobox by hightlighting and pressing delete, then the checkbox should be unchecked.

SO, I wrote a change event associated with the combobox and did
If Me.ComMSPS.Column(1) = "" Then
Me.Expedite = Flase
Else
Me.Expedite = True
EndIf

Even If i clear the combobox, it shows the old value.

How do I capture the surent value in the combobox??

 

[bjackson]

put your code in the after update event of the combo box,
shift the focus to another control then shift the focus back to the
combo box