Search results for query: *

CautionMP, I think you were correct in your assessment about the LinkChildFields & LinkMasterFields limiting my results. However, I can't figure out how to correct it.

Even when I hard code in the name and take out the DISTINCT, my results are still getting filtered. Instead of returning 19 entries, I get two. I've taken out the cascading feature too in attempt to simplify things, but I still can't get it to work. Sigh. Here's my latest code. Private Sub...

I don't think so. I think something in these two lines of code is limiting the results: strSQLSF = "SELECT DISTINCT Pipeline.[Lead_Person(s)] FROM Pipeline " strSQLSF = strSQLSF & " WHERE Pipeline.[Lead_Person(s)] LIKE '*" & S_MD_CB & "*'

Since it's a small DB, all of the entries are typed correctly, but I'll add the additional code for future. So, that's not the problem. Any other thoughts? Thanks for your help.

S_MD_CB is a combo box whose values are linked to a table called S_MD_Names that contains last names. Row Source: SELECT S_MD_Names.LastName FROM S_MD_Names ORDER BY S_MD_Names.LastName; I am then taking this input and trying to search another table called Pipeline to find all records with...

When I do that, not all of the results are returned. Only a selected few are returned.

I have a combo box that is filtering a form. The combo box contains employee's last name. However, the field that it is looking up can contain more than one name (e.g., possibilities include just Smith, Smith & Johnson, Smith & Jones & Johnson, etc.). Thus, when I click on the combo box, I want...