Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Idiot Proof Form - Search Next or Find Next

0

Hi there, this site is amazing.  I am working on a data entry form - but I do have duplicate records (intentionally unfortuantely).  I watched the idiot proof forms (which was so helpful)... but it only allows for one search option.  I have spent hours trying to google and search youtube to try and figure out how I can add some sort of 'next' button if the first Smith isnt the right one.  I've tried a couple different options - but they dont work and I only end up messing up the original code I worked so hard on. 

Any help would be greatly apprecaited. Thank you so much. -Betty

Answer
Discuss

Discussion

Hi Betty, sorry for the late reply, you need to use .FindNext after the .Find method in order to do this.
If you have working sample code, edit your quesiton and put it there or a sample file that is working and it should be pretty easy to get a findnext  solution for you. Otherwise, here is microsoft's page for it: FindNext Method MS Office Docs
don (rep: 1989) Sep 12, '20 at 3:37 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login