Ron,

Since you want the second listbox to show 'all' matching names, then you
can't filter on CustomerID. You'll have to incorporate the Customer's name
into the rowsource for List59, so you'll have to modify the SQL (below) for
both listboxes to reflect the actual CustomerName and Customers Table.

There may be better ways to do it, but hopefully this will give a decent
jumping off point.

Brian

.List59: (listbox 1)
SELECT [tblCustomers].CustomerName, [Order Date Query].StartDate, [Order
Date Query].Expr1, [Order Date Query].CustPhone, [Order Date Query].OrderID
FROM [Order Date Query]
INNER JOIN tblCustomers ON
[Order Date Query].[CustomerID] = [tblCustomers].[CustomerID];

List111: (listbox 2)
SELECT [Customer Query].CustomerID, [Customer Query].[CustomerName],
[Customer Query].StartDate, [Customer Query].Phone, [Customer Query].OrderID
FROM [Customer Query]
WHERE ((([Customer Query].CustomerName) Like "*" &
[Forms]![OrderDateForm].[list59] & "*"));

Ron,

Does [Order Date Query] include the customer's name?  If not, can it be
modified so that it does include the customer's name?  And then for this
field to be included in the Row Source of List59?  How about [Customer
Query], does that include the customer's name?  If not, can it be
modified so that it does include the customer's name?  If you can set
that up, then you will be able to modify the Where criteria for the
query you use for List111, so that it points to the customer name
instead of the CustomerID.