Hey Jerry,  Richard explains the basic LIKE function in Access Beginner 5 Video 3 in a query.  Example: ZipCode LIKE "12345".  You can manipulate the "12345" with a field on your form (textbox, combobox).  I don't know all where to locate all the videos, but you will need to understand some basics.  LIKE function, Quotes in a string (numbers), and basics of a SELECT statement.

Doesn't the combo box do that by default? Or are you wanting to change what is offered inside of the combo box based on what's typed?

The same concept is covered in the Search Seminar Search as you type in text boxes.

If you click in, or tab to, and start typing in a combo box it will do what you're asking.  You don't have to do anything special.  Unless I'm not understanding the question.

Now what happens when you select the value in the combo box is a whole different topic.  Go watch the Relational Combo for more onfo.

Ha - Guess I should refresh before I hit submit Adam.  At least we think similar.

BTW Jerry -

Richard has a very comprehensive search for the forum up on the main menu bar. For instance go type "Combo Box" and you will get multiple results - both in the courses and the TechHelp Videos.

Sorry only meant to upload 2 images, the first and the second.  The other ones can be deleted.

Thanks for the replies but here is my form with the combo box in image I have typed "Ca" and thats all it shows and in image two is where I clicked on the down arrow.  Am I maybe suppose to put some in the "On Change: event?

I got it, your replies got me to thining I needed to put some vba code in the on change event so this is what I came up with

Private Sub Combo20_Change()


Dim strText, strFind

If Len(Trim(strText)) > 0 Then
    strFind = "ProdName Like '"
    For i = 1 To Len(Trim(strText))
        If (Right(strFind, 1) = "*") Then
            strFind = Left(strFind, Len(strFind) - 1)
        End If
        strFind = strFind & "*" & Mid(strText, i, 1) & "*"
    Next
    strFind = strFind & "'"
    
    strSQL = "SELECT [ProductT].[ID], [ProductT].[ProdName] FROM ProductT Where " & _
    strFind & " ORDER BY [ProdName];"
    
    Me.Combo20.RowSource = strSQL
    
Else
    ' Show the entire list.
    strSQL = "SELECT [ProductT].[ID], [ProductT].[ProdName] FROM ProductT ORDER BY [ProdName]; "
    Me.Combo20.RowSource = strSQL
End If

Me.Combo20.Dropdown

End Sub



Again thanks for pushing me in the right direction