Build a query to bring all the fields together from each of the tables and base your form off of that query. Now you will have a text value to search on instead of the ID.

Remember to also change the object name in your code from the table to the query.

Please provide additional information.  It's difficult to advise how to proceed when we don't know what you have done.

A screen shot or two and the code you are using goes a long way.

I'm pulling directly from a table. One of my professors in college claimed that basing forms on queries made them more agile so I used to go overboard. Learning there's a cleaner way of doing things I've been an eager(perhaps over eager) convert. Here's my code:
Private Sub SearchBox_Change()
    Me.RecordSource = "SELECT * FROM DelicaProjectT " & _
        "WHERE " & _
            "BeadTypeID LIKE ""*" & SearchBox.Text & "*"" OR " & _
            "ProjectTypeID LIKE ""*" & SearchBox.Text & "*"" OR " & _
            "ProjectName LIKE ""*" & SearchBox.Text & "*"" OR " & _
            "DesignerID LIKE ""*" & SearchBox.Text & "*"""
    SearchBox.SetFocus
    SearchBox.SelStart = Len(SearchBox.Text)
End Sub

Kevin, I tried building a query but I couldn't wrap my head around how to convert the ID numbers to text inside a query. If you could expand on that it may well solve a difficulty I have with a completely different database. I may be trying to build to much at once, is that possible, lol?

Here is a sample query showing the text field to search on added to the query. The 2 tables are joined by the ID.

Got the query! I've linked my form to it, and now my SearchBox kicks back an "Enter Parameter Value", even when I copy paste them from the query. When I click debug it highlights from me.recordsource all the way thru the last or statement. Here's my code:

Private Sub SearchBox_Change()
    Me.RecordSource = "SELECT * FROM DelicaProjectT " & _
        "WHERE " & _
            "BeadType LIKE ""*" & SearchBox.Text & "*"" OR " & _
            "ProjectType LIKE ""*" & SearchBox.Text & "*"" OR " & _
            "ProjectName LIKE ""*" & SearchBox.Text & "*"" OR " & _
            "Designer LIKE ""*" & SearchBox.Text & "*"""
    SearchBox.SetFocus
    SearchBox.SelStart = Len(SearchBox.Text)
End Sub

Enter parameter value... what? What field is it looking for. Usually a misspelling. Enter Parameter Value

You need to change from DelicaProjectT to the name of your query.
I also forgot this step when I tested it and got the same error.