Combo box

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have a combo box to select a name which works correctly. What I would
like to do, as the user may need to select the same name a number of
times in succession when inputing data, is to have the last selected
name to be put at the top of the list until another name is selected
then that name to be put at the top etc.....

Thanks in anticipation, Regards, Mike
 
I have a combo box to select a name which works correctly. What I would
like to do, as the user may need to select the same name a number of
times in succession when inputing data, is to have the last selected
name to be put at the top of the list until another name is selected
then that name to be put at the top etc.....

Thanks in anticipation, Regards, Mike
Click to expand...

You don't need to move the selected name up.

The Combo box is bound to the name field?
If so, code the Combo Box AfterUpdate event:

Me![ComboName].DefaultValue = Me![ComboName]

Whichever name was first selected becomes the default for each new
record entered, until a different name is selected.
 
Back
Top