Refreshing a controls value

[Guest]

I have a combo box control. I used the BeforeUpdate event to validate the
entered value. If the value is unacceptable, I use the undo command to
return to the previous value.

This works, but the "unacceptable" value remains until I move to another
record and then return to the record I'm working on. I've tried Recalc,
Requery, Refresh, and Repaint of both the form and the control but nothing
works.

Any recommendations?

 

[Allen Browne]

The combo is bound to a control?

If you are undoing it, but the change does not show, I'm guessing that the
control has a different name from the field, and you are undoing the field.
Try undoing the combo instead.