Find Next Button Combobox - How To Create Advanced Search Forms, Filters, Parameters, and Dynamic Queries in Microsoft Access


	Back to Search Seminar Lessons Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Find Next Button Combobox

Ricky-Lee Erickson

4 years ago

I'm having errors coming up with the Find Next button, even after following your instructions and also with the already made forms in the Search Seminar Database.

"Run-time error 2143': You didn't specify search criteria with a FindRecord action."

Lesson number 09: Embedded macros, time 17:46

Kevin Robertson @Reply

4 years ago

Very strange problem. I just tested it and run into the same problem.

I entered a FindRecord command before the FindNextRecord command. I then went back to the form and performed the FindNext. No error..
I then went back into the Macro Editor and deleted the FindRecord command. The Button now works as expected. Very weird.

I also did the same for the VBA version.
Try it and let us know if it works.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Search Seminar Lessons.

Next Unseen

New Feature: Comment Live View