Search and display a record on a userform

Hi, nice challenge.
I'll pick this up later today and see if I can help, got some sample code with similar actions.
I haven't looked at the file yet but what information would like to see in a summary list of the selection?
I imagine you also want an extra button so show the entire record too of the selected item?

https://www.excelforum.com/excel-pro...-userform.html
The file in Post#4 will give you an idea on how to proceed.

Your table a has 70 columns named Column99
Is this intentional or a slick of the mouse click
What would you like to use as search a field to enter anything and match if it's found in the of the columns?
Like I asked this morning what you want to see of the record once selected?
Wouldn't be a bad idea to answer questions, I hate to make assumptions and then come up with something that is not what was asked.

Hi, you'll be awake or waking up now, I'm off to bed.
I edited your blank FindForm and maybe this helps you, you will have to add the code to show the data with the selected record, but see if this the idea you were looking for

I gave the table a name , i don't like default names like Table 1 and so
I cleared the empty table rows your code will have to include add table row or delete table row or whatever.
Try the form and see if it works for you,
When the form opens you can type text in the textbox and it will search-as-you-type
I'm off to bed.

Glad to hear that.
Happy coding

Hi, it seems that there wre some problems with the hosting server and I could not post an answer.
Glad you liked it and hope you can put it to good use.
I have attached a slightly modified version of the userform.
Added a reset (when you have typed or selected something) and place the actual record counter below the search box
Next to the Cancel button a textbox that will contain the selected record number (row in the table which is not the row in the worksheet)
You could use the forms you have but need to add the possibility to read a selected record and show the values, this to avoid adding extra forms with almost the same code.

See if you can make something of this short explanation but I would like to help if you need it.

Another option (and this is the last time I'll stalk you )
I added a column to the table (at the end) and hid it, is contains all the records concatenated into one cell per row (except the dates) and the alignment is shrink to fit because you do not need to read it.
In the (ActiveX) textbox you just start typing what you want and the filter will filter the data using that last column contains criterium on-the-fly
If the database becomes bigger there will be a little lag, but it works, then you just need to add code to select a record using either doubleclick or right click

Well, one more then
Try this one, it permits to select view and edit a record. No distinction between view and edit, but y=it selects a record and you can edit it and submit the changes.
Have not tested everything but give it a shot.

Phew, sorry for the late reply, I was away for the weekend and didn't have access to my files!

Not be over the top, but your work is fantastic.

I did work on a new user-form to use for viewing and editing, which is designed to provide all the information on one screen - so the user can get a quick overview without having to go through the tedious next/back sections like for the create new userform.
I have attached a document with the userform I would like to use - I'm not 100% sure if I got it right - I want it to display information that cannot be changed, but can still be highlighted for copy/pasting by user (eg. they want to copy and paste across into a word doc. or for printing a label) and then the edit option would be for changing or adding to the record. I can't seem to wrap my head around how to link the search result with auto-filling the form though.

(I seem to be getting an error when using the edit/view selected row button). I might not have merged the code/documents correctly.
Edit. Updated the document upload - fixed up some stray code/double up caused by merge.

'Morning, I'm off to work now, will check it out this afternoon.

I checked the file you attached, but you left out all the code I modified in the userforms to make it work , so no wonder it won't work with your form added.

Well, that means or I correct all the code but don't know if you added modifications in this file outside copying some of my code and adding your userform.
I think I'll copy your userform to the last version I uploaded and see if I can do something with it.

Can you explain what you want to achieve with is ViewForm you added?
It's full of Listboxes instead of Textbox fields? If it's to view then you view a record, but now I honestly do not understand what you want to do with this form
you added the folloing 'explanation'in the vba code

'when activated, we want the list boxes to be populated.
'list boxes used to prevent editing, but also to allow copying an highlighting of content

'type of trader

A listbox is to show a list not a single value, a textbox can be used and set it locked so it cannot be edited.
I honestly do no understand this form

I made some modifications to the code so it works and no errors but no filling of the userform.
I have attached the V3 file again but with your 'construction' for the viewing and since the Listbox give no indication of which field is which listbox you've got some 'homework'

The worksheet UserformControls shows the list of all the controls for the 4 userforms, CorpForm, IAForm, SoleTraderForm and ViewForm with the 'anonymous' listboxes.

Hi there, I hope my tone didn't scare you off. I took a look at what you tried and made modifications, The VBA-code of this file all fits together so if you want to use it in your own file you will have to take all the modules.
I also noticed that you (probably by accident) change the last table's column formula (hidden one) and this caused that not all records would be identified if you started typing something, Annies pies was not selectable.
I reorganized your ViewForm and address it using code I found.
Try this file out with that dat that is there.
There is A Reference worksheet (hidden) that is used to populate the viewform and could also be used when reading data for any of the other three forms, but that is not yet tested.

The EDIT button and the Edit in the find window all invoke the ViewForm and the fields are locked. Listboxes are not the solution for what you were trying to do.
I have three global booleans AddData, EditData and ViewData which are set for each situation using the UDf setWhat

I learned some new tricks while rewriting your code and looking for a way to simplify things, so this was a fun challenge as well as a learning moment

Minor corrections and added a Prev and Next button to the ViewForm

You're welcome

I suggest you start your own post with this question and attach the file too