list box with 'recently' used combo box values

  • Thread starter Thread starter Samantha
  • Start date Start date
S

Samantha

Hello,
I have a list of objects in a combo box...I want to
display in a seperate list box the latest 5values selected
in the combo box.
Just for the application of having..
'The recently selected values are:'

Thank you for your suggestions in advance.
Samantha
 
Rather than basing the listbox on a query, as is normally done, you can base
it on a value list, and write the 5 values, separated by semi-colons, as the
Row Source. In the AfterUpdate event of your combobox, you'd have to read
the Row Source for the list box, throw away the first entry and add the most
recent selection from the combo box at the end.
 
In addition to Doug's suggestion, if you wanted to persist this across
"sessions", you'd have to save it somewhere, like in a table, then read it
again when the application is again opened.
 
Back
Top