Behavior of combo boxes under VBA

[Anja]

Hi everyone,

I have a combo box that has some values. So, when the access file is
opened, this combo box does not show any value and he user can click on
it and then select the values.

What I want to do is programatically reset the combo box again, so set
its current value to nothing just like it was when the form was opened.
Any ideas on how to do this from VBA??

Thanks you. I appreciate any help you can give me.

Best regards,

Anja

 

[Douglas J. Steele]

I'm not sure I follow completely.

When you say that the combo box doesn't show any value, do you mean that
nothing's been selected, so that the box appears empty, or that when you
open the combo box, there's nothing in it to choose from?

If you simply don't want anything selected, set the combo box to Null:

Me.MyComboBox = Null

 

[Anja]

I'm not sure I follow completely.

When you say that the combo box doesn't show any value, do you mean that
nothing's been selected, so that the box appears empty, or that when you
open the combo box, there's nothing in it to choose from?

If you simply don't want anything selected, set the combo box to Null:

Me.MyComboBox = Null

That is exactly what I needed! Thanks a lot!