Set up an unbound options group (I'll call it "FirstLetter") with 26 buttons, one for each letter. Be sure to set up the buttons in alphabetical order so that the option value for button A is 1, B is 2, Z is 26.
Set the on update property of FirstLetter to run code something like the following:
Dim strLetter As String
Dim strLetterHigh As String
strLetter = Chr(64 + Me.FirstLetter)
strLetterHigh = strLetter & "ZZZZZZZZZZZZZZ"
me.Filter = "[LName] BETWEEN '" & strLetter _
& "' And '"& strLetterHigh & "'"
me.FilterOn=True
me.Requery
The way this will work is as follows:
When the user clicks on a button (selects a letter), the value of strLetter is set to that letter by using the option value (1-26) and adding 64 to get theASCII codes for A-Z.
StrLetterHigh is set to the letter plus trailing ZZZ's as the highest possible value in the range. (I'm assuming that the driving query/table is sorted alphabetically, so the names will be listed alphabetically.)
The filter for the form is then set so the last name is between the two values. (Example, user clicks on C, the filter will be [LName] BETWEEN 'C' And 'CZZZZZZZZ')
The filteron property of the form is set to true so the filter will be used. Me.Requery then forces the form to requery its source table/query.
You could also add to the form a box where the user could enter the beginning letters of a last name and when the box was updated use similar code but make the filter limit the displayed names to the range between the letters entered by the user and the letters entered by the user plus ZZZZZZ. This could be useful for a large list of names where the first letter does not reduce the number of names listed sufficiently.