Link to home
Start Free TrialLog in
Avatar of John Carroll
John CarrollFlag for Canada

asked on

Access 2010: How to filter subform by first letter

Can anyone tell me the best way to filter a subform by first letter? My guess is to use an option group with a button for each letter A-Z. There should be a way with code using Select Case or If ElseIf where if you click on the "A" button you only see last names (in this case) that begin with A and so on. Am I on the right track or is there a better way?
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial