Search Form

Hi.

1 - I wish it were like a kind of research as well, where I typed the name and it will automatically appear for me in this combo box.
2 - When the name sought is found, I would click on it and all your data automatically appear in the form.
3 - How to make a statement that there is no name repeated in the combo box?
4 - How do I get the user only has the vision of form and not the worksheet?
I thank you all!

marreco,

What is the command button that you use for the "Search".
As for the Combobox for the "Name" when you start to type the name it will scroll to the nearest word and you can now use the dropdown for the name.

Hi.Charles

What is the command button that you use for the "Search".

I wish that after typing the name in the combo box, click to two, the name in the combo box.

After that all other controls would be filled.

but if you can not do as well as the power had been done to me great, thanks!

As for the Combobox for the "Name" when you start to type the name it will scroll to the nearest word and you can now use the dropdown for the name.

would be exactly that way!

marreco,

Another problem. You are loading the combobox from the "Customer" sheet. If you enter the name for the search. How do you know if it found the correct record?
The find function will find the first name in the file.
Also, After you enter the name "What button do you click" to start the find? Are you wanting to double click on the name?

Hi.

You are loading the combobox from the "Customer" sheet. If you enter the name for the search. How do you know if it found the correct record?

Consider that I have unique information on the worksheet

Are you wanting to double click on the name?

Yes!!

thank you!!

Hi,

Then you get the fist record and then click another button to goto the next record.
What button would you use?

Consider that I have unique information on the worksheet

I do not understand very well but for this case would be the command button called "Avançar" . which is equal to the "next" in the case of English

Thanks, I'll try to put something together. But, may not get it done this PM.

Hi,

I have some code worked out.
You will need to finish adding the code for the userform.
I have in place code for "Next" and "Previous"
I do not have code for "Duplicate" names that are in the "Customers" sheet.
Look at the codes for the combobox and the Next and Previous. You will see a pattern as to how you need to finish them.
You can click the "Clients" and it will show the userform.
Will be gone tomorrow, but if necessary will pick up on Tuesday.

When you close the form is experiencing an error.

Run-time Error '91 ':
The object variable or block variable 'with' not defined

Hi,

Go to the code for the form "Initialize" and remove the ".Show" that should take care of the error.
Will be gone the rest of today.

part of the error was right now, thank you!

Hi,

Just returned. Will look at your project tomorrow for updates. Were you able to add the missing part of the code for the userform?

Yes, but there are still some things to add.

thanks

marreco,

Hi I added code to load the userform combo with out duplicates. Also I removed the code for "initialize".
I have the new code in module.

Thank you!!! Charles.

was very good!