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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top