search criteria

putadokta · #1 (**permalink**) 01-26-12, 06:16

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

Sinndho · #2 (**permalink**) 01-26-12, 07:15

Every button could call a procedure like:

Code:

Private Sub SortForm(Byval FirstLetter As String)

    If Len(FirstLetter) > 0 Then
        strFilter = "SomeField LIKE '" & FirstLetter & "*'"
        Me.Filter = strFilter
        Me.FilterOn = True
    Else
        Me.FilterOn = False
    End If

End Sub

It's very difficult to be more specific without knowing anything about your database.

putadokta · #3 (**permalink**) 01-26-12, 08:49

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

putadokta · #4 (**permalink**) 01-26-12, 09:01

The database Music_Access2010.zip

putadokta · #5 (**permalink**) 01-27-12, 23:47

problem solved

Internet Services

Web Development

Digital Marketing

Consumer Tech