Say I have a form showing some fields of a single record of a table, "Customer" for example.
The default way of navigating between the records is using the controls provided by access (arrows on the bottom).  I don't know any other way.

I want to create a better way to navigate:
- Create a list control displaying the customer names sorted alphabetically. (I know how to do that).
- Allow the user to browse through them, and click on one. Once clicked I want the active record to change to that customer. How do I do that? Do I need to use VB?
- If possible, have a search box in which I type a partial string from the customer's name and have the system display all matches, allowing me to click on one and then have the active record change to that customer.

How do I do this?

---

Reply from Richard Rost:

Yes, this is all possible. I cover all of it in my classes. I show you how to make a customer list form that you can browse and click on a record to open in Access 2010 Beginner 7.

The combo box to search for a specific customer is covered in Access 2010 Beginner 8. Enjoy.