I'm not clear how the name format forces you to need a listbox or
combobox.

Is the last name, first name format in one column?

Would it be useful to parse the name to two columns and name them
first name and last name?

Dan Dungan


The format for the names is last then first,
so i need the listbox or combo box to house the names, then when i
select the name it will load the data in the cells to the right, the
names have to stay in alphabetical order. i have 6 different forms so
its kind of a complicated situation this is the only part im having
trouble with. :(