MS Acces: How do you search a record using a form?

Question

Suppose you have a table with five names:Jon Smith,Jon Smith JR, Jon Smith JR1, Jon Smith JR2, Jon Smith JR3.Now you create a form and you want to edit Jon Smith JR2.You have five times "Jon Smith" one of which is JR2. I type: "Jon S" and "Jon Smith" appears. How do I make the form go to "Jon Smith JR2" by hitting for example a button or tab or whatever. Cause when I hit next button on bottom of form it just gos to next record.And I have 2000 names in the database.So how do I search the data tables to find a record by using the form?Hope I make sense on what I say.

Answer 1

you need to create a button and a variable field. Let's say that you can type what you want in that field. i.e. "Jon" or "Jon S" or "Jon Smith JR2".

When you click the button, it executes a sql statement that does a search for whatever is in the variable field + *. Where * is anything. So, if you had entered "Jon" Then it should search for "Jon*".

I hope you understand what I'm telling you.