Hi to one and all This is my first post here.. I hope that you can help me I am developing a database The database needs to list the records in a listbox and then when a record is clicked the details come up, The problem i have is I need a method for getting/filtering all the records that begin with First character into the listbox. I have 27 command buttons listed down the page from A-Z, when one is clicked the listbox needs to filter the Full name that begin with that letter
Any pointers or help would be much appreciated ACCESS 2010
Private Sub SortForm(Byval FirstLetter As String)
If Len(FirstLetter) > 0 Then
strFilter = "SomeField LIKE '" & FirstLetter & "*'"
Me.Filter = strFilter
Me.FilterOn = True
Me.FilterOn = False
It's very difficult to be more specific without knowing anything about your database.
What I am trying to achieve is instead of using a dropdown box all The time. Is when you click a button i.e 'P' just the Artists name appears in a list box or the dropdown box. Because when I have finished updating the records The dropdown box way is going to be to long to scroll. I am enclosing Database to see if you understand me And thank you for your reply