Hi Tophan
If you want to show all records try this..make sure the 'ALL' button is named btnAll
Private Sub btnAll_Click() 'Show all records
DoCmd.ShowAllRecords
End Sub
The sub to group entries beginning with several letters you suggested would only work if entries in the field began with...