Populate Userform With Listbox Search Result

[sgf0568]

I have a userform (UserForm1) to add information to a database (Log). I created an advanced search for searches where there could be more than one result. Selecting the advanced search opens a 2nd userform (UserForm2) that contains a listbox for the search results. All of this works perfectly so far. What I want to happen is to select a result from the listbox and have all the information from that record displayed on the original userform (UserForm1). However, there are 34 columns of information that make up a single record. The listbox only contains 2 columns of information with the value in the first column being the unique identifier for the record. After many days of reading various forums I have been unsuccessful in making this happen. Could anyone help me?

[6StringJazzer]

Please give instructions for how to use your file up to the point where you can select a record in the listbox, and what action you would want to take to load the other form.

Roughly just based on your description, you have two options. One is to use the selection to search for the data in a worksheet then load all the data into the form from there. The other one is to update your listbox to have 32 hidden columns and take the data directly from there when the item is selected.

[Sintek]

Here are a few pointers...See attached sample file...
Instead of having code to populate Comboboxes...Rather store data in a hidden sheet and populate as follows...

Please Login or Register  to view this content.

I would neaten up your Userform Interface and keep the control numbering in order...For easy looping etc etc...
I would keep the Search functionality on the same Form...No need for 2 forms...
Select search criteria and then start typing in search box...Listbox will retain all valid searches...
Double click on item in listbox and boxes above will populate...

On opening of file click button above...This was just for testing purpose...Code can be place in an Auto_Open module...

Anyway...Food for thought...Good luck...Happy Coding...
I am sure others will hop on board and offer more valuable advice...

[bakerman2]

You already have a code to search for NCR so I kept to the original as much as possible.

I only restiled your search function to use AdvancedFilter instead of searching cells 1 by 1.

So open Advanced search, type item nr to search for, select item in Listbox.

[sgf0568]

Thanks to all that have replied. I'm at my place of employment and IT security is pretty tight so I can't look at any examples of what has been done. I will look at them tonight when I get home. Thanks for the help.