combo box selection List

[A Hopper]

How can I create a select list for a combo box that has
two levels? When the selection arrow is clicked I would
like to get the list of lastest selections (temporary
list) from most recent choice down and a "look up" (option)
which has all the information in a table (e.g employee
names and numbers). If a "look up" is done and a selection
made, the selection becomes the first item in the
selection list for the combo box. To keep the list in
control I would also like to purge the most recent choice
list either when the form is closed or limit the list to
eight and when the item becomes the nineth choice it will
be purged.

Thanks
Allan

 

[Larry Linson]

If I understand, you want to use one Combo Box for this sequence of
operations. That is not, of course, the way Combo Boxes operate.

And, I am having some difficulty following your description of exactly what
you want to do.

It is _possible_ that with ingenuity and user-written code that you might be
able to accomplish what you want, but to do it with a single Combo Box is
not going to be easy.

As best I understand, you have one list of choices, each of which has a
related sublist. Then, if a selection is made from the sublist, you want to
keep a record of that, but only up to eight.

If I am correct in that understanding, the simple and straightforward way to
handle it would be with two Combo Boxes for the selections and a List Box to
show the selected items. The selected items could either be written to a
table or kept in an array to populate the List Box.

But, if you will clarify, perhaps someone can offer a suggestion.

Larry Linson
Microsoft Access MVP