Clearing combobox with AfterUpdate event

[Max Moor]

Hi All,
I have a combobox that I use to setup some form options. I do this
with its AfterUpdate event. After doing the work, I'd like to clear the
box. I've tried by setting the focus and writting "" to the text property,
but Access says I can't because of the AfterUpdate event. How can I clear
the box without "catch-22'ing" myself?

- Max

 

[Ken Snell]

Write to the combo box's Value property instead of the Text property.

 

[Max Moor]

Write to the combo box's Value property instead of the Text property.

Yes!!! Darned if I haven't used that before, too. It was totally out of
my mind. I've swear, I've learned so much about Access in the last few
months that the new stuff is pushing out the older stuff. sigh Thanks so
much, Ken.

- Max