Select next in drop down list

[stu_c]

Hi All.
I have a drop down list and within it has pre defined text templates that users can select click insert text button and then goes into the main body of a text box.
is there a VBA code that will automatically go to the next text selection below automatically within the list so the user doesn't always have to click the next line?

Dropdown List name: CmbTemplateText

 

[theDBguy]

Perhaps check out the ListIndex property?

 

[tvanstiphout]

I'm working on a similar project. We have a list of templates which are fragments of a letter, to be inserted at the insertion point into a large textbox upon a button click (or if a listbox, upon double-click).
The dropdown would have 2 columns: select TemplateID, TemplateName from tblTemplates order by TemplateName, with columnwidths "0;1" to hide the ID column.
If user selects some entry, why would you assume that she then wants to select the next one? Maybe they want to insert #3, #6, and then #2.
But if I really, really wanted to do that, I would set the value of the combobox to the value of the next ID value of the list, by opening a recordset on the RowSource of the dropdown, finding the current value, MoveNext, and setting the dropdown to that ID value.

 

[Pat Hartman]

is there a VBA code that will automatically go to the next text selection below automatically within the list so the user doesn't always have to click the next line?

This does not sound like a good idea but Tom told you how to do it.