regarding item 2; there is a way to, as you type in a few characters, to have
selections become available based on the 'partial match or matches' that meet
the characters that have been typed so far. I had a project 2 years ago that
used this type of logic.

If you use a combobox you can get it to do this. You set its MatchEntry
property to 1-fmMatchEntryComplete

I only know how to use combo box from the Forms toolbar.
Can you show me how to build combo boxes using Control Toolbox instead of Forms?

You just click the combobox on the toolbar and then click in you ws whereyou
want it. Then you right click and click Properties. Set the properties
accordingly.

When you click the design mode button in the toolbar to take it out of design
mode the combobox is activated. Put the reference to a range for the list  in
ListFillRange.

If you have any specific issues get back to the list.

It was easier than I thought. Thank you so much for your instructions.