Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Help   Contact   Merch   Join   Order   Logon   Forums   
 
Home > Courses > Access > Seminars > Genealogy > Filter Combo Box and Record Navigation by Tom Juric >
Back to Access Genealogy Seminar    Comments List
Upload Images | @Reply | Bookmark | Link | Email | Next Unseen |
Filter Combo Box and Record Navigation
Tom Juric 
      
3 days ago
How do I create a search box and navigation buttons for Person form?

A.  I want to create a Combo box that will:
      1. display members by last name then first (Juric, Thomas A) and update combo box as I type into the box (I start with J and box shows all "J", then "u" and box displays all members last name "Ju" and so on.
      2. When I click on a name from the combo box above, the Person form displays the name chosen and all associated data.

B. How do I create navigation buttons for the Person form. The standard buttons are too small to be seen well on some computers. I cannot get the buttons to go to the record

If I have to create two separarte requests I can do that.
Donald Blackwell  @Reply  
       
3 days ago
Tom

For filtering a combo box as you type, you can check out these videos:

Filter Combo

Fitness 29

If you're referring to the built-in navigation buttons at the bottoms of forms, you can just create command buttons using the control wizards. In the wizard, choose "Record Navigation" and then you can choose Go to First, Go To Previous, Go To Next, and Go to Last.

Or if you want to customize it more, we can help you with VBA. Or, when you're ready, Access Developer 49 shows how to build a fully customizable navigation template that can be dropped in as a sub-form. But again, it is VBA intense.
Richard Rost  @Reply  
           
3 days ago
Thanks for the pointers, Donald. Tom, those two questions fit together fine here.

For the combo, keep two jobs separate: narrowing the list as you type, and navigating to the selected person's record. Filter Combo covers the first part. Ordinary Auto Expand only jumps to a matching entry; it doesn't reduce the list. That lesson searches anywhere in the displayed name, so for your J, Ju example you'd use a starts-with match instead.

For the second part, use an unbound search combo that identifies each person by PersonID, with the name displayed as last name, comma, first name. Don't bind that search combo to a field in the current person's record. You want to find a person, not change the person you're already viewing. The Combo Box Wizard's record-finding option is a good starting point on a form bound to a table or saved query.

For the bigger buttons, start with Donald's wizard approach. One thing to check: if PersonF was opened filtered to just one person, Next/Previous can only move within that one-record set. They don't automatically navigate everyone in PersonT. What happens when you click your buttons: nothing, an error, or the wrong record? Post the button's On Click macro/code and how you're opening PersonF, and we can narrow it down.
Add a Reply Upload an Image
Next Unseen

 
 
What's This?

 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 11/21/2026 4:42:58 AM. PLT: 0s