Thanks Jeanette,

I was hoping that was possible... I tested putting an sql statement (copied
from a query) in the recordsource property directly, and it crashed access.
So, I'll take your word for it that vba can do it.

Now on to the tricky part....
In order to 'filter' by Salesperson (Salesperson is related to Sales Order
via a junction table, since a Sales Order may have more than one
Salesperson). Here's the sql:

SELECT [Record-Orders-Sales].*, [Query-Junction-Cust_Account].*,
[Junction-SalesOrder_Contractors].AssociatedContractorID
FROM ([Record-Orders-Sales] INNER JOIN [Query-Junction-Cust_Account] ON
[Record-Orders-Sales].[AssociatedCustAcct#Junction] =
[Query-Junction-Cust_Account].JunctionID) INNER JOIN
[Junction-SalesOrder_Contractors] ON [Record-Orders-Sales].SalesOrderID =
[Junction-SalesOrder_Contractors].AssociatedSalesOrderID
WHERE
((([Junction-SalesOrder_Contractors].AssociatedContractorID)=[Forms]![Entry-SalesOrder]![Filter-SalesRep1]))
ORDER BY [Record-Orders-Sales].SalesOrderID;

In order to filter by 2 sales peeps, I'd want to add to the string ala Allen
Browne's filter model, but the a bit I'd need to add would be 'injected' into
the above sql, not at the end.

Here's what the sql would look like for filter by 2 sales peeps, (again,
from a query (that works)).
SELECT [Record-Orders-Sales].*, [Query-Junction-Cust_Account].*,
[Junction-SalesOrder_Contractors].AssociatedContractorID,
[Junction-SalesOrder_Contractors_1].AssociatedContractorID
FROM ([Junction-SalesOrder_Contractors] AS
[Junction-SalesOrder_Contractors_1] INNER JOIN ([Record-Orders-Sales] INNER
JOIN [Query-Junction-Cust_Account] ON
[Record-Orders-Sales].[AssociatedCustAcct#Junction] =
[Query-Junction-Cust_Account].JunctionID) ON
[Junction-SalesOrder_Contractors_1].AssociatedSalesOrderID =
[Record-Orders-Sales].SalesOrderID) INNER JOIN
[Junction-SalesOrder_Contractors] ON [Record-Orders-Sales].SalesOrderID =
[Junction-SalesOrder_Contractors].AssociatedSalesOrderID
WHERE
((([Junction-SalesOrder_Contractors].AssociatedContractorID)=[Forms]![Entry-SalesOrder]![Filter-SalesRep1])
AND
(([Junction-SalesOrder_Contractors_1].AssociatedContractorID)=[Forms]![Entry-SalesOrder]![Filter-SalesRep2]))
ORDER BY [Record-Orders-Sales].SalesOrderID;

It's the same as the first version, with the
[Junction-SalesOrder_Contractors_1] bits added. The trick is that it's added
kind of in the middle. For this one instance, I'm sure I could make it work,
but I want to make a model that I could scale to allow building the
recordsource sql to include other factors, and need a systematic way to add
to the sqlString.

Any advice?