John Carroll
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.