Combo Box

[A Hopper]

I posted this originally with two other questions. I has
been suggested that I post them seperately.

How do I design a combo box so that the last item selected
from the list becomes the default (or moves to the top of
the list) until the user selects a new item from the list?

If the list of selected items grows, how do I clear the
list and start over with the original list?

Thanks for your help

Allan

 

[Jen]

Not sure if you're saying you want a combobox (allows
users to select 1 value) or a listbox (user can select
multiple values)? Maybe you could give a little more info
on what you're trying to do.

Regards,
Jen

 

[A Hopper]

Sorry Jen,
I want to use a combobox that allows users to select 1
value.

Thanks for your response
Allan

 

[A Hopper]

-----Original Message-----
Sorry Jen,
I want to use a combobox that allows users to select 1
value and after the value is selected it will become the

default (or move to the first of the list) until another
selection is made from the list. The user will not need to
scroll through the list if they are using the same
selection.

 

[Ken Snell]

You could use code similar to this in the combo box's AfterUpdate event (it
sets the default value to the item last selected):

Private Sub cboBoxName_AfterUpdate()
Me.cboBoxName.DefaultValue = """" & Me.cboBoxName.Value & """"
End Sub