Yes, maybe Access would have been better for this, but a friend asked me to string it together in Excel as he understands Excel a little better than Access.
I have a sheet with maybe 20 columns, aka Fields
Each Row is a record (As it should be)
The Rows are all part of a formal table.
I have created a form with labels and textboxes for each field, which presently can easily add a row to the table and insert all data (Yes, I know, very basic for you gurus!).
I have always been lousy at working comboboxes into searches, and perhaps I should be using listboxes.
I want him to be able to start typing in a name in a box and as he types the choices within the db of accumulated contacts is narrowed down by the letters input until there is a suitable handful that he can choose from, select one, and upon selection it would bring up the respective fields from the flat db located on a sheet into the userform for review, editing or deletion.
Does anyone know of a good example or tutorial that I can download and study? I would really love the workbook shown at the top of this page, but for the life of me I can't figure out how to get it, even though it appears it was intended for download! That example is above and beyond what I need for this occasion, but I really want to learn how to do something with all the capabilities it has (but not necessarily the butterflies...).
As always, the help I get from you folks is above amazing and I thank-you!
Edit: With a little more "looking" I see that the page I thought was the solution I wanted, really isn't. It relies on a textbox-to-autofilter, where I rather have a combobox or listbox that displays several columns of information so if a name is in there twice, say, "John Smith", then also other fields, perhaps address, would show to differentiate between records for selection.
Bookmarks